CREATE TABLE table_name_78 (college VARCHAR2, team VARCHAR2, position VARCHAR2)

What college has the Chicago stags and position is G?
SELECT college FROM table_name_78 WHERE team = "chicago stags" AND position = "g"
SELECT "college" FROM "table_name_78" WHERE "chicago stags" = "team" AND "g" = "position"