user: ### NOW ANSWER:
Question: Which Total has a Country of United States, and a Player of Andy North?
Columns: ['Player', 'Country', 'Year(s) won', 'Total', 'To par', 'Finish']
Types: ['text', 'text', 'text', 'real', 'text', 'text']
Sample row: ['Scott Simpson', 'United States', '1987', 282.0, '–6', '2']
SQL:

assistant: SELECT AVG("Total") FROM "Table" WHERE "Country" = 'United States' AND "Player" = 'Andy North';