SELECT cName FROM  tryout WHERE pPos  =  'goalie' INTERSECT SELECT cName FROM  tryout WHERE pPos  =  'mid'
Find the names of schools that have some students playing in goalie and mid positions.
SELECT cName FROM tryout WHERE pPos = 'goalie ' INTERSECT SELECT cName FROM tryout WHERE pPos = 'mid '
select cname from tryout where ppos = value intersect select cname from tryout where ppos = value
Find the names of schools that have some students playing in goalie and mid positions .