user: Question: How many caps did mitchell duke have overall?
Columns: ['Player', 'Country', 'Caps', 'Goals', 'Years Active']
Types: ['text', 'text', 'real', 'text', 'text']
Sample row: ['Michael McGlinchey', 'New Zealand', 22.0, '(3)', '2009–']
SQL:

assistant: SELECT "Caps" FROM "Table" WHERE "Player" = 'mitchell duke';