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

Show the name of each county along with the corresponding number of delegates from that county Plot them as bar chart, display bar from high to low 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 County_name DESC
SELECT "County_name", COUNT(*) FROM "county" "T1" JOIN "election" "T2" ON "T1"."County_Id" = "T2"."District" GROUP BY "T1"."County_Id" ORDER BY "County_name" DESC