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

Find the names of schools that have some players in the mid position but not in the goalie position.
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'