CREATE TABLE table_24540893_6 (player VARCHAR, cfl_team VARCHAR)

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