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.
SQL: SELECT SUM(Enrollment), affiliation FROM university WHERE founded > 1850 GROUP BY affiliation