Table: cfl_draft_2008
Columns: pick
cfl_team
player
position
college

Question: Which College has a Pick # larger than 30, and a Position of ol?
SQL: SELECT "college" FROM cfl_draft_2008 WHERE "pick" > 30 AND "position" = 'ol'

Question: Which Pick # has a College of concordia?
SQL: SELECT MAX("pick") FROM cfl_draft_2008 WHERE "college" = 'concordia'

Question: Which CFL Team has a Pick # larger than 31?
SQL: SELECT "cfl_team" FROM cfl_draft_2008 WHERE "pick" > 31

Question: What is buffalo's pick #?
SQL: SELECT MAX("pick") FROM cfl_draft_2008 WHERE "college" = 'buffalo'

Question: Which College has a Position of ol, and a Pick # smaller than 32?
SQL: SELECT "college" FROM cfl_draft_2008 WHERE "position" = 'ol' AND "pick" < 32