Database: university_basketball
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