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

What are the different parties of representative? Show the party name and the number of representatives in each party, order in asc by the Y-axis.
SELECT Party, COUNT(*) FROM representative GROUP BY Party ORDER BY COUNT(*)
SELECT "Party", COUNT(*) FROM "representative" GROUP BY "Party" ORDER BY COUNT(*)