Show the parties that have both representatives in New York state and representatives in Pennsylvania state.
CREATE TABLE representative (Party VARCHAR, State VARCHAR)
SELECT Party FROM representative WHERE State = "New York" INTERSECT SELECT Party FROM representative WHERE State = "Pennsylvania"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE representative (Party VARCHAR, State VARCHAR) Question: Show the parties that have both representatives in New York state and representatives in Pennsylvania state. [/INST] SELECT Party FROM representative WHERE State = "New York" INTERSECT SELECT Party FROM representative WHERE State = "Pennsylvania" </s>