Table: cfl_draft_2000
Columns: pick
cfl_team
player
position
school

Question: Who was drafted by the calgary stampeders?
SQL: SELECT "player" FROM cfl_draft_2000 WHERE "cfl_team" = 'Calgary Stampeders'

Question: Where was the player from se missouri state drafted?
SQL: SELECT COUNT("pick") FROM cfl_draft_2000 WHERE "school" = 'SE Missouri State'

Question: What position does the player from kent state play?
SQL: SELECT "position" FROM cfl_draft_2000 WHERE "school" = 'Kent State'

Question: What school did the rb drafted attend?
SQL: SELECT "school" FROM cfl_draft_2000 WHERE "position" = 'RB'

Question: What numbered pick attended western ontario and is an OL?
SQL: SELECT "pick" FROM cfl_draft_2000 WHERE "school" = 'Western Ontario' AND "position" = 'OL'

Question: How many players attended SE missouri state?
SQL: SELECT COUNT("position") FROM cfl_draft_2000 WHERE "school" = 'SE Missouri State'