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

What college has a student who successfully made the team in the role of a goalie?
SELECT cname FROM tryout WHERE decision = 'yes' AND ppos = 'goalie'
SELECT "cname" FROM "tryout" WHERE "decision" = 'yes' AND "ppos" = 'goalie'