CREATE TABLE table_20170644_1 (cfl_team VARCHAR, player VARCHAR)

What CFL team did simeon rottier play for?
SELECT cfl_team FROM table_20170644_1 WHERE player = "Simeon Rottier"
SELECT "cfl_team" FROM "table_20170644_1" WHERE "Simeon Rottier" = "player"