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)

What is the number of states that has some colleges whose enrollment is smaller 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")