Task: Text to Code
Input (English): Step 1: find the Membership_card of member table for which member's Address equals Hartford.
Step 2: For each row in shop table, find the corresponding rows in member table.
Step 3: find Membership_card of the results of step 2 whose shop's Address equals Waterbury.
Step 4: show the rows that are in both the results of step 1 and the results of step 3
Output (English): SELECT T1.Membership_card FROM member AS T1 WHERE T1.Address = "Hartford" INTERSECT SELECT T1.Membership_card FROM shop AS T2 JOIN member AS T1 WHERE T2.Address = "Waterbury"