How many caps for mike macdonald?
CREATE TABLE table_name_30 (caps INTEGER, player VARCHAR)
SELECT SUM(caps) FROM table_name_30 WHERE player = "mike macdonald"
### Context: CREATE TABLE table_name_30 (caps INTEGER, player VARCHAR) ### Question: How many caps for mike macdonald? ### Answer: SELECT SUM(caps) FROM table_name_30 WHERE player = "mike macdonald"