SELECT COUNT(*) FROM (SELECT cName FROM  tryout WHERE pPos  =  'goalie' INTERSECT SELECT cName FROM  tryout WHERE pPos  =  'mid')
How many schools have students playing in goalie and mid-field positions?
SELECT COUNT ( * ) FROM ( SELECT cName FROM tryout WHERE pPos = 'goalie ' INTERSECT SELECT cName FROM tryout WHERE pPos = 'mid ' )
select count ( * ) from ( select cname from tryout where ppos = value intersect select cname from tryout where ppos = value )
How many schools have students playing in goalie and mid-field positions ?