Table: cfl_draft_2004_2
Columns: pick
cfl_team
player
position
college

Question: What college did Craig Zimmer go to?
SQL: SELECT "college" FROM cfl_draft_2004_2 WHERE "player" = 'Craig Zimmer'

Question: What is the pick number of regina?
SQL: SELECT "pick" FROM cfl_draft_2004_2 WHERE "college" = 'Regina'

Question: What is the player who is lb and cfl team is saskatchewan roughriders?
SQL: SELECT "player" FROM cfl_draft_2004_2 WHERE "position" = 'LB' AND "cfl_team" = 'Saskatchewan Roughriders'

Question: What is the cfl team that has a position of ol?
SQL: SELECT "cfl_team" FROM cfl_draft_2004_2 WHERE "position" = 'OL'

Question: What is the number of position where the pick number is 43?
SQL: SELECT COUNT("position") FROM cfl_draft_2004_2 WHERE "pick" = 43

Question: What is the cfl team with ryan folk?
SQL: SELECT "cfl_team" FROM cfl_draft_2004_2 WHERE "player" = 'Ryan Folk'