CREATE TABLE table_name_59 (shooter VARCHAR, score VARCHAR)

Who was the shooter with a score of 686.4?
SELECT shooter FROM table_name_59 WHERE score = "686.4"
SELECT "shooter" FROM "table_name_59" WHERE "686.4" = "score"