CREATE TABLE tryout (pid DECIMAL, cname TEXT, ppos TEXT, decision TEXT)
CREATE TABLE college (cname TEXT, state TEXT, enr DECIMAL)
CREATE TABLE player (pid DECIMAL, pname TEXT, ycard TEXT, hs DECIMAL)

What are the names of the schools with some players in the mid position but no goalies?
SELECT cname FROM tryout WHERE ppos = 'mid' EXCEPT SELECT cname FROM tryout WHERE ppos = 'goalie'
SELECT "cname" FROM "tryout" WHERE "ppos" = 'mid' EXCEPT SELECT "cname" FROM "tryout" WHERE "ppos" = 'goalie'