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

Show the name of each party and the corresponding number of delegates from that party in a bar chart, sort in desc by the the average of count(*) please.
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(*)) DESC
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(*)) DESC NULLS LAST