Find the names of schools that have some students playing in goalie and mid positions.
create table tryout (cname varchar, ppos varchar, PRIMARY KEY (cname))
select cname from tryout where ppos = 'goalie' intersect select cname from tryout where ppos = 'mid'