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

What is the total number of students enrolled in schools without any goalies?
SELECT SUM(enr) FROM college WHERE NOT cname IN (SELECT cname FROM tryout WHERE ppos = "goalie")
SELECT SUM("enr") FROM "college" WHERE NOT "cname" IN (SELECT "cname" FROM "tryout" WHERE "goalie" = "ppos")