Table: cfl_draft_2006_2
Columns: pick
cfl_team
player
position
college

Question: which CFL team has a player called Peter Hogarth?
SQL: SELECT "cfl_team" FROM cfl_draft_2006_2 WHERE "player" = 'peter hogarth'

Question: which college has a player called Riley Clayton?
SQL: SELECT "college" FROM cfl_draft_2006_2 WHERE "player" = 'riley clayton'