What are the different parties of representative? Show the party name and the number of representatives in each party.
CREATE TABLE election (
    election_id number,
    representative_id number,
    date text,
    votes number,
    vote_percent number,
    seats number,
    place number
)

CREATE TABLE representative (
    representative_id number,
    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: 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 number,
    representative_id number,
    date text,
    votes number,
    vote_percent number,
    seats number,
    place number
)

CREATE TABLE representative (
    representative_id number,
    name text,
    state text,
    party text,
    lifespan text
) ### Response: SELECT party, COUNT(*) FROM representative GROUP BY party