What is the membership card held by both members living in Hartford and ones living in Waterbury address?
CREATE TABLE member (membership_card VARCHAR, address VARCHAR)
SELECT membership_card FROM member WHERE address = 'Hartford' INTERSECT SELECT membership_card FROM member WHERE address = 'Waterbury'
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE member (membership_card VARCHAR, address VARCHAR) Question: What is the membership card held by both members living in Hartford and ones living in Waterbury address? [/INST] SELECT membership_card FROM member WHERE address = 'Hartford' INTERSECT SELECT membership_card FROM member WHERE address = 'Waterbury' </s>