CREATE TABLE table_name_97 (year INT, player VARCHAR)

What year was the player David Rose?
SELECT SUM(year) FROM table_name_97 WHERE player = "david rose"
SELECT SUM("year") FROM "table_name_97" WHERE "david rose" = "player"