Mostrar os nomes dos membros que estão tanto no partido com id 3 e no partido com 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