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

Bar chart of the total number from each party, I want to sort Y from high to low order please.
SELECT Party, COUNT(*) FROM representative GROUP BY Party ORDER BY COUNT(*) DESC
SELECT "Party", COUNT(*) FROM "representative" GROUP BY "Party" ORDER BY COUNT(*) DESC NULLS LAST