CREATE TABLE election (Election_ID NUMBER, Representative_ID NUMBER, Date CLOB, Votes FLOAT, Vote_Percent FLOAT, Seats FLOAT, Place FLOAT)
CREATE TABLE representative (Representative_ID NUMBER, Name CLOB, State CLOB, Party CLOB, Lifespan CLOB)

A bar chart showing how many representatives in each party, could you order in descending by the x-axis?
SELECT Party, COUNT(Party) FROM representative GROUP BY Party ORDER BY Party DESC
SELECT "Party", COUNT("Party") FROM "representative" GROUP BY "Party" ORDER BY "Party" DESC