Table: cfl_players
Columns: pick
cfl_team
player
position
college

Question: What position is Justin Shaw in?
SQL: SELECT "position" FROM cfl_players WHERE "player" = 'Justin Shaw'

Question: What pick # did Western Illinois have?
SQL: SELECT "pick" FROM cfl_players WHERE "college" = 'Western Illinois'

Question: How many cfl teams had pick # 21?
SQL: SELECT COUNT("cfl_team") FROM cfl_players WHERE "pick" = 21

Question: How many pick numbers did Michael Giffin have?
SQL: SELECT COUNT("pick") FROM cfl_players WHERE "player" = 'Michael Giffin'

Question: What college does Jean-Nicolas Carriere play for?
SQL: SELECT "college" FROM cfl_players WHERE "player" = 'Jean-Nicolas Carriere'