Database: university_basketball
Question: What are the total enrollments of universities of each affiliation type?
SQL:
SELECT sum(enrollment) ,  affiliation FROM university GROUP BY affiliation