How many distinct parties are there for representatives?
CREATE TABLE representative (
    representative_id number,
    name text,
    state text,
    party text,
    lifespan text
)

CREATE TABLE election (
    election_id number,
    representative_id number,
    date text,
    votes number,
    vote_percent number,
    seats number,
    place number
)
SELECT COUNT(DISTINCT party) FROM representative
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: How many distinct parties are there for representatives? ### Input: CREATE TABLE representative (
    representative_id number,
    name text,
    state text,
    party text,
    lifespan text
)

CREATE TABLE election (
    election_id number,
    representative_id number,
    date text,
    votes number,
    vote_percent number,
    seats number,
    place number
) ### Response: SELECT COUNT(DISTINCT party) FROM representative