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

What is the total number of enrollment of schools that do not have any goalie player?
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")