CREATE TABLE university (affiliation VARCHAR, enrollment INT)

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