CREATE TABLE table_name_23 (cfl_team VARCHAR2, player VARCHAR2)

which CFL team has a player called Peter Hogarth?
SELECT cfl_team FROM table_name_23 WHERE player = "peter hogarth"
SELECT "cfl_team" FROM "table_name_23" WHERE "peter hogarth" = "player"