CREATE TABLE table_41680 ("Pick #" FLOAT, "CFL Team" CLOB, "Player" CLOB, "Position" CLOB, "College" CLOB)

What CFL team did Kelly Bates play for?
SELECT "CFL Team" FROM table_41680 WHERE "Player" = 'kelly bates'
SELECT "CFL Team" FROM "table_41680" WHERE "Player" = 'kelly bates'