SELECT cName FROM  tryout WHERE pPos  =  'mid' EXCEPT SELECT cName FROM  tryout WHERE pPos  =  'goalie'
Find the names of schools that have some players in the mid position but not in the goalie position.
SELECT cName FROM tryout WHERE pPos = 'mid ' EXCEPT SELECT cName FROM tryout WHERE pPos = 'goalie '
select cname from tryout where ppos = value except select cname from tryout where ppos = value
Find the names of schools that have some players in the mid position but not in the goalie position .