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

which CFL team has a player called Peter Hogarth?
SELECT "CFL Team" FROM table_11242 WHERE "Player" = 'peter hogarth'
SELECT "CFL Team" FROM "table_11242" WHERE "Player" = 'peter hogarth'