user: ### NOW ANSWER:
Question: How many players played for Adams State school?
Columns: ['Pick #', 'CFL Team', 'Player', 'Position', 'College']
Types: ['real', 'text', 'text', 'text', 'text']
Sample row: [45.0, 'Calgary Stampeders', 'Brett Ralph', 'WR', 'Alberta']
SQL:

assistant: SELECT COUNT("Player") FROM "Table" WHERE "College" = 'Adams State';