user: ### NOW ANSWER:
Question: How many totals have Andy North as the player?
Columns: ['Player', 'Country', 'Year(s) won', 'Total', 'To par', 'Finish']
Types: ['text', 'text', 'text', 'real', 'text', 'text']
Sample row: ['Tom Watson', 'United States', '1982', 281.0, '–3', '2']
SQL:

assistant: SELECT SUM("Total") FROM "Table" WHERE "Player" = 'Andy North';