instruction: Find the total student enrollment for different affiliation type schools Plot them as bar chart, could you rank by the names from high to low?
response: SELECT Affiliation, SUM(Enrollment) FROM university GROUP BY Affiliation ORDER BY Affiliation DESC