Table: cfl_draft_2009
Columns: pick
cfl_team
player
position
college

Question: What CFL team did Darcy Brown play for?
SQL: SELECT "cfl_team" FROM cfl_draft_2009 WHERE "player" = 'Darcy Brown'

Question: What CFL team did simeon rottier play for?
SQL: SELECT "cfl_team" FROM cfl_draft_2009 WHERE "player" = 'Simeon Rottier'

Question: What college did étienne légaré play for?
SQL: SELECT "college" FROM cfl_draft_2009 WHERE "player" = 'Étienne Légaré'

Question: What team was in position OL?
SQL: SELECT "cfl_team" FROM cfl_draft_2009 WHERE "position" = 'OL'

Question: Who was the player for the CFL team hamilton tiger-cats (via bc via saskatchewan )?
SQL: SELECT "player" FROM cfl_draft_2009 WHERE "cfl_team" = 'Hamilton Tiger-Cats (via BC via Saskatchewan )'

Question: What number pick did the CFL team bc lions (via hamilton via winnipeg ) have?
SQL: SELECT MAX("pick") FROM cfl_draft_2009 WHERE "cfl_team" = 'BC Lions (via Hamilton via Winnipeg )'