CREATE TABLE basketball_match (Team_ID INT, School_ID INT, Team_Name TEXT, ACC_Regular_Season TEXT, ACC_Percent TEXT, ACC_Home TEXT, ACC_Road TEXT, All_Games TEXT, All_Games_Percent INT, All_Home TEXT, All_Road TEXT, All_Neutral TEXT)
CREATE TABLE university (School_ID INT, School TEXT, Location TEXT, Founded FLOAT, Affiliation TEXT, Enrollment FLOAT, Nickname TEXT, Primary_conference TEXT)

Find the total student enrollment for different affiliation type schools. Plot them as bar chart.
SELECT Affiliation, SUM(Enrollment) FROM university GROUP BY Affiliation
SELECT "Affiliation", SUM("Enrollment") FROM "university" GROUP BY "Affiliation"