CREATE TABLE table_name_45 (league_goals INT, player VARCHAR)

How many total League goals does Player John O'Flynn have?
SELECT SUM(league_goals) FROM table_name_45 WHERE player = "john o'flynn"
SELECT SUM("league_goals") FROM "table_name_45" WHERE "john o'flynn" = "player"