user: Question: How many times did Alyn McCauley get picked?
Columns: ['Pick', 'Player', 'Position', 'Nationality', 'NHL team', 'College/junior/club team']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['79.', 'Alyn McCauley', 'Centre', 'Canada', 'New Jersey Devils (from Ottawa)', "Ottawa 67's (OHL)"]
SQL:

assistant: SELECT COUNT("Pick") FROM "Table" WHERE "Player" = 'Alyn McCauley';