CREATE TABLE county (County_Id NUMBER, County_name CLOB, Population FLOAT, Zip_code CLOB)
CREATE TABLE election (Election_ID NUMBER, Counties_Represented CLOB, District NUMBER, Delegate CLOB, Party NUMBER, First_Elected FLOAT, Committee CLOB)
CREATE TABLE party (Party_ID NUMBER, Year FLOAT, Party CLOB, Governor CLOB, Lieutenant_Governor CLOB, Comptroller CLOB, Attorney_General CLOB, US_Senate CLOB)

For each party, return the name of the party and the number of delegates from that party Plot them as bar chart, and could you rank in ascending by the bar?
SELECT T2.Party, AVG(COUNT(*)) FROM election AS T1 JOIN party AS T2 ON T1.Party = T2.Party_ID GROUP BY T2.Party ORDER BY T2.Party
SELECT "T2"."Party", AVG(COUNT(*)) FROM "election" "T1" JOIN "party" "T2" ON "T1"."Party" = "T2"."Party_ID" GROUP BY "T2"."Party" ORDER BY "T2"."Party"