CREATE TABLE representative (Representative_ID INT, Name TEXT, State TEXT, Party TEXT, Lifespan TEXT)
CREATE TABLE election (Election_ID INT, Representative_ID INT, Date TEXT, 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, sort names in descending order.
SELECT Party, COUNT(*) FROM representative GROUP BY Party ORDER BY Party DESC
SELECT "Party", COUNT(*) FROM "representative" GROUP BY "Party" ORDER BY "Party" DESC NULLS LAST