Schema: CREATE TABLE tryout (pPos VARCHAR)
Question: How many students whose are playing the role of goalie?
SQL: SELECT COUNT(*) FROM tryout WHERE pPos = 'goalie'