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