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

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