Table: cfl_draft_2004_4
Columns: pick
cfl_team
player
position
college

Question: What is Rhett Mclane's highest pick number?
SQL: SELECT MAX("pick") FROM cfl_draft_2004_4 WHERE "player" = 'rhett mclane'

Question: What is Colorado College's lowest pick number?
SQL: SELECT MIN("pick") FROM cfl_draft_2004_4 WHERE "college" = 'colorado'

Question: What player belongs to Northwestern College?
SQL: SELECT "player" FROM cfl_draft_2004_4 WHERE "college" = 'northwestern'

Question: What CFL Team is Pascal Masson on?
SQL: SELECT "cfl_team" FROM cfl_draft_2004_4 WHERE "player" = 'pascal masson'