Table: cfl_draft_97
Columns: pick
cfl_team
player
position
college

Question: How many pick# for CFL team of Toronto Argonauts?
SQL: SELECT COUNT("pick") FROM cfl_draft_97 WHERE "cfl_team" = 'Toronto Argonauts'

Question: What is every CFL team from the Calgary college?
SQL: SELECT "cfl_team" FROM cfl_draft_97 WHERE "college" = 'Calgary'

Question: What is every position for the CFL Edmonton?
SQL: SELECT "position" FROM cfl_draft_97 WHERE "cfl_team" = 'Edmonton'

Question: What is every CFL team for the college of Calgary?
SQL: SELECT "cfl_team" FROM cfl_draft_97 WHERE "college" = 'Calgary'

Question: What is every CFL team with pick#1?
SQL: SELECT "cfl_team" FROM cfl_draft_97 WHERE "pick" = 1

Question: What is every CFL team with the player Mark Farraway?
SQL: SELECT "cfl_team" FROM cfl_draft_97 WHERE "player" = 'Mark Farraway'