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)

A bar chart showing how many representatives in each party, and I want to display Y-axis from low to high order.
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") NULLS FIRST