CREATE TABLE college (state VARCHAR2, enr NUMBER)

Find the states where have the colleges whose enrollments are less than the largest size.
SELECT DISTINCT state FROM college WHERE enr < (SELECT MAX(enr) FROM college)
SELECT DISTINCT "state" FROM "college" WHERE "enr" < (SELECT MAX("enr") FROM "college")