Table: cfl_draft_97
Columns: pick
cfl_team
player
position
college

Question: Name the cfl team for patrice denis
SQL: SELECT "cfl_team" FROM cfl_draft_97 WHERE "player" = 'Patrice Denis'

Question: Name the cfl team for robert beveridge
SQL: SELECT "cfl_team" FROM cfl_draft_97 WHERE "player" = 'Robert Beveridge'

Question: Name the college for dl
SQL: SELECT "college" FROM cfl_draft_97 WHERE "position" = 'DL'

Question: Name the number of colleges for jerome pathon
SQL: SELECT COUNT("college") FROM cfl_draft_97 WHERE "player" = 'Jerome Pathon'

Question: Name the number of cfl teams for jeff traversy
SQL: SELECT COUNT("cfl_team") FROM cfl_draft_97 WHERE "player" = 'Jeff Traversy'

Question: Name the position for british columbia
SQL: SELECT "position" FROM cfl_draft_97 WHERE "college" = 'British Columbia'