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)
CREATE TABLE election (Election_ID NUMBER, Counties_Represented CLOB, District NUMBER, Delegate CLOB, Party NUMBER, First_Elected FLOAT, Committee CLOB)

How many delegates in each committee? Return a bar chart, I want to order in descending by the X.
SELECT Committee, COUNT(Committee) FROM election GROUP BY Committee ORDER BY Committee DESC
SELECT "Committee", COUNT("Committee") FROM "election" GROUP BY "Committee" ORDER BY "Committee" DESC