CREATE TABLE tryout (pid NUMBER, cname CLOB, ppos CLOB, decision CLOB)
CREATE TABLE college (cname CLOB, state CLOB, enr NUMBER)
CREATE TABLE player (pid NUMBER, pname CLOB, ycard CLOB, hs NUMBER)

Which college has any student who is a goalie and succeeded in the tryout.
SELECT cname FROM tryout WHERE decision = 'yes' AND ppos = 'goalie'
SELECT "cname" FROM "tryout" WHERE "decision" = 'yes' AND "ppos" = 'goalie'