SELECT Party, COUNT(Party) FROM representative GROUP BY Party ORDER BY Party DESC
A bar chart showing how many representatives in each party, could you order in descending by the x-axis?
CREATE TABLE election (
    Election_ID int,
    Representative_ID int,
    Date text,
    Votes real,
    Vote_Percent real,
    Seats real,
    Place real
)

CREATE TABLE representative (
    Representative_ID int,
    Name text,
    State text,
    Party text,
    Lifespan text
)