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)

Return all the committees that have delegates from Democratic party, and count them by a pie chart
SELECT Committee, COUNT(Committee) FROM election AS T1 JOIN party AS T2 ON T1.Party = T2.Party_ID WHERE T2.Party = "Democratic" GROUP BY Committee
SELECT "Committee", COUNT("Committee") FROM "election" "T1" JOIN "party" "T2" ON "Democratic" = "T2"."Party" AND "T1"."Party" = "T2"."Party_ID" GROUP BY "Committee"