user: ### NOW ANSWER:
Question: How many caps for Mike MacDonald?
Columns: ['Player', 'Position', 'Date of Birth (Age)', 'Caps', 'Club/province']
Types: ['text', 'text', 'text', 'real', 'text']
Sample row: ['Blake Burdette', 'Hooker', '19 January 1980', 5.0, 'NYAC']
SQL:

assistant: SELECT SUM("Caps") FROM "Table" WHERE "Player" = 'Mike MacDonald';