CREATE TABLE table_name_45 (college VARCHAR2, player VARCHAR2)

What is Mark Cannon's College?
SELECT college FROM table_name_45 WHERE player = "mark cannon"
SELECT "college" FROM "table_name_45" WHERE "mark cannon" = "player"