Table schema:
CREATE TABLE table_name_96 (total INTEGER, player VARCHAR)

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