Plot how many party by grouped by party as a bar graph, could you rank by the total number from low to high?
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
)
SELECT Party, COUNT(Party) FROM representative GROUP BY Party ORDER BY COUNT(Party)
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Plot how many party by grouped by party as a bar graph, could you rank by the total number from low to high? ### Input: 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
) ### Response: SELECT Party, COUNT(Party) FROM representative GROUP BY Party ORDER BY COUNT(Party)