CREATE TABLE representative (representative_id NUMBER, name CLOB, state CLOB, party CLOB, lifespan CLOB)
CREATE TABLE election (election_id NUMBER, representative_id NUMBER, date CLOB, votes NUMBER, vote_percent NUMBER, seats NUMBER, place NUMBER)

How many distinct parties are there for representatives?
SELECT COUNT(DISTINCT party) FROM representative
SELECT COUNT(DISTINCT "party") FROM "representative"