Which college has any student who is a goalie and succeeded in the tryout.
create table tryout (cname varchar, decision varchar, ppos varchar, PRIMARY KEY (cname))
select cname from tryout where decision = 'yes' and ppos = 'goalie'