Show the member names which are in both the party with id 3 and the party with id 1.
CREATE TABLE member (member_name VARCHAR, party_id VARCHAR)
SELECT member_name FROM member WHERE party_id = 3 INTERSECT SELECT member_name FROM member WHERE party_id = 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE member (member_name VARCHAR, party_id VARCHAR) Question: Show the member names which are in both the party with id 3 and the party with id 1. [/INST] SELECT member_name FROM member WHERE party_id = 3 INTERSECT SELECT member_name FROM member WHERE party_id = 1 </s>