What is the number of states that has some college whose enrollment is larger than the average enrollment?
CREATE TABLE college (state VARCHAR, enr INTEGER)
SELECT COUNT(DISTINCT state) FROM college WHERE enr > (SELECT AVG(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: What is the number of states that has some college whose enrollment is larger than the average enrollment? [/INST] SELECT COUNT(DISTINCT state) FROM college WHERE enr > (SELECT AVG(enr) FROM college) </s>