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

What are the states with colleges that have enrollments less than the some other college?
SELECT DISTINCT state FROM college WHERE enr < (SELECT MAX(enr) FROM college)
SELECT DISTINCT "state" FROM "college" WHERE "enr" < (SELECT MAX("enr") FROM "college")