CREATE TABLE table_name_96 (total INT, player VARCHAR)

How many totals have andy north as the player?
SELECT SUM(total) FROM table_name_96 WHERE player = "andy north"
SELECT SUM("total") FROM "table_name_96" WHERE "andy north" = "player"