SELECT DISTINCT state FROM college WHERE enr  <  (SELECT max(enr) FROM college)
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 )
What are the states with colleges that have enrollments less than the some other college ?