Table 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'