SELECT count(*) FROM tryout WHERE pPos  =  'goalie'
How many students whose are playing the role of goalie?
SELECT count ( * ) FROM tryout WHERE pPos = 'goalie '
select count ( * ) from tryout where ppos = value
How many students whose are playing the role of goalie ?