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)

Who were the governors of the parties associated with delegates from district 1, and count them by a bar chart, display total number from high to low order.
SELECT Governor, COUNT(Governor) FROM election AS T1 JOIN party AS T2 ON T1.Party = T2.Party_ID WHERE T1.District = 1 GROUP BY Governor ORDER BY COUNT(Governor) DESC
SELECT "Governor", COUNT("Governor") FROM "election" "T1" JOIN "party" "T2" ON "T1"."Party" = "T2"."Party_ID" WHERE "T1"."District" = 1 GROUP BY "Governor" ORDER BY COUNT("Governor") DESC