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

Show the parties that have both representatives in New York state and representatives in Pennsylvania state.
SELECT party FROM representative WHERE state = "New York" INTERSECT SELECT party FROM representative WHERE state = "Pennsylvania"
SELECT "party" FROM "representative" WHERE "New York" = "state" INTERSECT SELECT "party" FROM "representative" WHERE "Pennsylvania" = "state"