Table: cfl_draft_97_2
Columns: pick
cfl_team
player
position
college

Question: What draft pick number was Andy Brereton?
SQL: SELECT MIN("pick") FROM cfl_draft_97_2 WHERE "player" = 'Andy Brereton'

Question: What pick number was the player that was picked by Edmonton?
SQL: SELECT "pick" FROM cfl_draft_97_2 WHERE "cfl_team" = 'Edmonton'

Question: What position did the draft pick going to saskatchewan play?
SQL: SELECT "position" FROM cfl_draft_97_2 WHERE "cfl_team" = 'Saskatchewan'

Question: What is the highest numbered draft pick?
SQL: SELECT MAX("pick") FROM cfl_draft_97_2

Question: What CFL team got the player from york?
SQL: SELECT "cfl_team" FROM cfl_draft_97_2 WHERE "college" = 'York'

Question: How many positions does Trent Bagnail play?
SQL: SELECT COUNT("position") FROM cfl_draft_97_2 WHERE "player" = 'Trent Bagnail'