CREATE TABLE table_name_30 (caps INT, player VARCHAR)

How many caps for mike macdonald?
SELECT SUM(caps) FROM table_name_30 WHERE player = "mike macdonald"
SELECT SUM("caps") FROM "table_name_30" WHERE "mike macdonald" = "player"