CREATE TABLE table_26912 ("Pick #" FLOAT, "CFL Team" CLOB, "Player" CLOB, "Position" CLOB, "School" CLOB)

Who was drafted by the calgary stampeders?
SELECT "Player" FROM table_26912 WHERE "CFL Team" = 'Calgary Stampeders'
SELECT "Player" FROM "table_26912" WHERE "CFL Team" = 'Calgary Stampeders'