CREATE TABLE table_name_49 (college VARCHAR2, player VARCHAR2)

What is the College with a Player that is dean caliguire?
SELECT college FROM table_name_49 WHERE player = "dean caliguire"
SELECT "college" FROM "table_name_49" WHERE "dean caliguire" = "player"