Table: cfl_draft_2007
Columns: pick
cfl_team
player
position
college

Question: What college's team is the Saskatchewan Roughriders?
SQL: SELECT "college" FROM cfl_draft_2007 WHERE "cfl_team" = 'Saskatchewan Roughriders'

Question: What position did Calvin Mccarty play?
SQL: SELECT "position" FROM cfl_draft_2007 WHERE "player" = 'Calvin McCarty'

Question: How many people were pick #30?
SQL: SELECT COUNT("position") FROM cfl_draft_2007 WHERE "pick" = 30

Question: What college did Calvin McCarty play at?
SQL: SELECT "college" FROM cfl_draft_2007 WHERE "player" = 'Calvin McCarty'

Question: What college had a LB in the draft?
SQL: SELECT "college" FROM cfl_draft_2007 WHERE "position" = 'LB'