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

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'