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

Bar chart x axis acc road y axis total number of school id
SELECT ACC_Road, SUM(School_ID) FROM basketball_match GROUP BY ACC_Road
SELECT "ACC_Road", SUM("School_ID") FROM "basketball_match" GROUP BY "ACC_Road"