Return a pie on what are the different parties of representative? Show the party name and the number of representatives in each party.
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(*) 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: Return a pie on what are the different parties of representative? Show the party name and the number of representatives in each party. ### 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(*) FROM representative GROUP BY Party