Find the total number of students enrolled in the colleges that were founded after the year of 1850 for each affiliation type.
CREATE TABLE university (affiliation VARCHAR, Enrollment INTEGER, founded INTEGER)
SELECT SUM(Enrollment), affiliation FROM university WHERE founded > 1850 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, founded INTEGER) Question: Find the total number of students enrolled in the colleges that were founded after the year of 1850 for each affiliation type. [/INST] SELECT SUM(Enrollment), affiliation FROM university WHERE founded > 1850 GROUP BY affiliation </s>