Database: soccer_2
Question: What college has a student who successfully made the team in the role of a goalie?
SQL:
SELECT cName FROM  tryout WHERE decision  =  'yes' AND pPos  =  'goalie'