Table schema:
CREATE TABLE university (affiliation VARCHAR, enrollment INTEGER)

Question: Find the total student enrollment for different affiliation type schools.
SQL: SELECT SUM(enrollment), affiliation FROM university GROUP BY affiliation