CREATE TABLE table_name_32 (caps VARCHAR2, player VARCHAR2)

How many caps did Mitchell Duke have overall?
SELECT COUNT(caps) FROM table_name_32 WHERE player = "mitchell duke"
SELECT COUNT("caps") FROM "table_name_32" WHERE "mitchell duke" = "player"