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