Database: soccer_2
Question: How many students whose are playing the role of goalie?
SQL:
SELECT count(*) FROM tryout WHERE pPos  =  'goalie'