Find the states where have the colleges whose enrollments are less than the largest size.
CREATE TABLE college (state VARCHAR, enr INTEGER)
SELECT DISTINCT state FROM college WHERE enr < (SELECT MAX(enr) FROM college)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE college (state VARCHAR, enr INTEGER) Question: Find the states where have the colleges whose enrollments are less than the largest size. [/INST] SELECT DISTINCT state FROM college WHERE enr < (SELECT MAX(enr) FROM college) </s>