What can you tell me about the students who made the team?
select * from tryout where decision = 'yes'
of those, who tried out for the position of goalie?
select * from tryout where decision = 'yes' and ppos = 'goalie'
What college do they attend?
select cname from tryout where decision = 'yes' and ppos = 'goalie'