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

Show the name of each party and the corresponding number of delegates from that party, and sort in asc by the Y-axis.
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 AVG(COUNT(*))
SELECT "T2"."Party", AVG(COUNT(*)) FROM "election" "T1" JOIN "party" "T2" ON "T1"."Party" = "T2"."Party_ID" GROUP BY "T2"."Party" ORDER BY AVG(COUNT(*))