Table: cfl_draft_2004
Columns: pick
cfl_team
player
position
college

Question: How many colleges have a DB position?
SQL: SELECT COUNT("college") FROM cfl_draft_2004 WHERE "position" = 'DB'

Question: What is the maximum number of picks for the CFL team Calgary Stampeders?
SQL: SELECT MAX("pick") FROM cfl_draft_2004 WHERE "cfl_team" = 'Calgary Stampeders'

Question: How many CFL teams are from York college?
SQL: SELECT COUNT("cfl_team") FROM cfl_draft_2004 WHERE "college" = 'York'

Question: What CFL teams are part of Simon Fraser college?
SQL: SELECT "cfl_team" FROM cfl_draft_2004 WHERE "college" = 'Simon Fraser'

Question: Which players have a pick number of 27?
SQL: SELECT "player" FROM cfl_draft_2004 WHERE "pick" = 27