Table schema:
CREATE TABLE table_24540893_6 (player VARCHAR, cfl_team VARCHAR)

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