CREATE TABLE table_name_32 (cfl_team VARCHAR, player VARCHAR)

What CFL team did Kelly Bates play for?
SELECT cfl_team FROM table_name_32 WHERE player = "kelly bates"
SELECT "cfl_team" FROM "table_name_32" WHERE "kelly bates" = "player"