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

What is the number of states that has some college whose enrollment is larger than the average enrollment?
SELECT COUNT(DISTINCT state) FROM college WHERE enr > (SELECT AVG(enr) FROM college)
SELECT COUNT(DISTINCT "state") FROM "college" WHERE "enr" > (SELECT AVG("enr") FROM "college")