Find the total student enrollment for different affiliation type schools.
CREATE TABLE university (affiliation VARCHAR, enrollment INTEGER)
SELECT SUM(enrollment), affiliation FROM university 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 total student enrollment for different affiliation type schools. [/INST] SELECT SUM(enrollment), affiliation FROM university GROUP BY affiliation </s>