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)
CREATE TABLE county (County_Id INT, County_name TEXT, Population FLOAT, Zip_code TEXT)

For each county, find the name of the county and the number of delegates from that county Show bar chart, could you order total number in desc order?
SELECT County_name, COUNT(*) FROM county AS T1 JOIN election AS T2 ON T1.County_Id = T2.District GROUP BY T1.County_Id ORDER BY COUNT(*) DESC
SELECT "County_name", COUNT(*) FROM "county" AS "T1" JOIN "election" AS "T2" ON "T1"."County_Id" = "T2"."District" GROUP BY "T1"."County_Id" ORDER BY COUNT(*) DESC NULLS LAST