SELECT cName FROM  tryout WHERE pPos  =  'goalie' INTERSECT SELECT cName FROM  tryout WHERE pPos  =  'mid'
What are the names of all schools that have students trying out for the position of goal and 'mid'-field.
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
What are the names of all schools that have students trying out for the position of goal and 'mid'-field .