CREATE TABLE table_name_96 (total INTEGER, player VARCHAR(255))
How many totals have andy north as the player?
    
SQL: SELECT SUM(total) FROM table_name_96 WHERE player = "andy north"