Find the number of universities that have over a 20000 enrollment size for each affiliation type.
CREATE TABLE university (affiliation VARCHAR, enrollment INTEGER)
SELECT COUNT(*), affiliation FROM university WHERE enrollment > 20000 GROUP BY affiliation
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE university (affiliation VARCHAR, enrollment INTEGER) Question: Find the number of universities that have over a 20000 enrollment size for each affiliation type. [/INST] SELECT COUNT(*), affiliation FROM university WHERE enrollment > 20000 GROUP BY affiliation </s>