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)
CREATE TABLE party (Party_ID NUMBER, Year FLOAT, Party CLOB, Governor CLOB, Lieutenant_Governor CLOB, Comptroller CLOB, Attorney_General CLOB, US_Senate CLOB)

A bar chart for finding the number of the parties associated with the delegates from district 1. Who served as governors of the parties?
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
SELECT "Governor", COUNT("Governor") FROM "election" "T1" JOIN "party" "T2" ON "T1"."Party" = "T2"."Party_ID" WHERE "T1"."District" = 1 GROUP BY "Governor"