SELECT sum(enr) FROM college WHERE cName NOT IN (SELECT cName FROM tryout WHERE pPos  =  "goalie")
What is the total number of enrollment of schools that do not have any goalie player?
SELECT sum ( enr ) FROM college WHERE cName NOT IN ( SELECT cName FROM tryout WHERE pPos = `` goalie '' )
select sum ( enr ) from college where cname not in ( select cname from tryout where ppos = value )
What is the total number of enrollment of schools that do not have any goalie player ?