CREATE TABLE representative (Party VARCHAR, State VARCHAR)

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"