Show the member names which are in both the party with id 3 and the party with id 1.
SELECT member_name FROM member WHERE party_id  =  3 INTERSECT SELECT member_name FROM member WHERE party_id  =  1
members in both parties refers to INTERSECT; member names refers to SELECT member_name; party with id X refers to WHERE party_id = X;