Bar chart of the total number from each party
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 real,
    Vote_Percent real,
    Seats real,
    Place real
)
SELECT Party, COUNT(*) FROM representative GROUP BY 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: Bar chart of the total number from each party ### Input: 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 real,
    Vote_Percent real,
    Seats real,
    Place real
) ### Response: SELECT Party, COUNT(*) FROM representative GROUP BY Party