CREATE TABLE table_8785 ("Player" CLOB, "Country" CLOB, "Year ( s )  won" CLOB, "Total" FLOAT, "To par" CLOB, "Finish" CLOB)

How many totals have andy north as the player?
SELECT SUM("Total") FROM table_8785 WHERE "Player" = 'andy north'
SELECT SUM("Total") FROM "table_8785" WHERE "Player" = 'andy north'