CREATE TABLE table_name_96 (score VARCHAR2, player VARCHAR2)

What was John Fought's score?
SELECT score FROM table_name_96 WHERE player = "john fought"
SELECT "score" FROM "table_name_96" WHERE "john fought" = "player"