Table: cfl_draft_2005
Columns: pick
cfl_team
player
position
college

Question: How many times were players named brett ralph were selected?
SQL: SELECT COUNT("pick") FROM cfl_draft_2005 WHERE "player" = 'Brett Ralph'

Question: What schools did lenard semajuste play for?
SQL: SELECT "college" FROM cfl_draft_2005 WHERE "player" = 'Lenard Semajuste'

Question: What is the highest selection number for the saskatchewan roughriders team?
SQL: SELECT MAX("pick") FROM cfl_draft_2005 WHERE "cfl_team" = 'Saskatchewan Roughriders'

Question: How many fb players were drafted?
SQL: SELECT COUNT("pick") FROM cfl_draft_2005 WHERE "position" = 'FB'

Question: How many players played for adams state school?
SQL: SELECT COUNT("player") FROM cfl_draft_2005 WHERE "college" = 'Adams State'

Question: What teams drafted players that played for northwood school?
SQL: SELECT "cfl_team" FROM cfl_draft_2005 WHERE "college" = 'Northwood'