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)

Plot how many party by grouped by party as a bar graph, could you rank by the total number from low to high?
SELECT Party, COUNT(Party) FROM representative GROUP BY Party ORDER BY COUNT(Party)
SELECT "Party", COUNT("Party") FROM "representative" GROUP BY "Party" ORDER BY COUNT("Party")