How many schools have some students playing in goalie and mid positions.
create table tryout (cname varchar, ppos varchar, PRIMARY KEY (cname))
select count(*) from (select cname from tryout where ppos = 'goalie' intersect select cname from tryout where ppos = 'mid')