CREATE TABLE table_name_40 (college VARCHAR2, player VARCHAR2)

What college did Keith Shologan play for?
SELECT college FROM table_name_40 WHERE player = "keith shologan"
SELECT "college" FROM "table_name_40" WHERE "keith shologan" = "player"