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

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'