Find the names of schools that have some players in the mid position but not in the goalie position.
create table tryout (cname varchar, ppos varchar, PRIMARY KEY (cname))
select cname from tryout where ppos = 'mid' except select cname from tryout where ppos = 'goalie'