Table: cfl_draft_2008_3
Columns: pick
cfl_team
player
position
college

Question: What is the sum of Pick #, when College is Laurier?
SQL: SELECT SUM("pick") FROM cfl_draft_2008_3 WHERE "college" = 'laurier'

Question: What is CFL Team, when Pick # is greater than 34, and when College is Boise State?
SQL: SELECT "cfl_team" FROM cfl_draft_2008_3 WHERE "pick" > 34 AND "college" = 'boise state'

Question: What is the lowest Pick #, when Position is REC, and when CFL Team is Hamilton Tiger-Cats?
SQL: SELECT MIN("pick") FROM cfl_draft_2008_3 WHERE "position" = 'rec' AND "cfl_team" = 'hamilton tiger-cats'

Question: What is Player, when Position is DB, and when College is Saint Mary's?
SQL: SELECT "player" FROM cfl_draft_2008_3 WHERE "position" = 'db' AND "college" = 'saint mary''s'

Question: What is Position, when Pick # is less than 40, and when College is Western?
SQL: SELECT "position" FROM cfl_draft_2008_3 WHERE "pick" < 40 AND "college" = 'western'