show the names of members living in Hartford.
select name from member where address = 'Hartford'
also those living in Waterbury.
select name from member where address = 'Waterbury'
which membership cards are held by members living in these two places?
select membership_card from member where address = 'Hartford' intersect select membership_card from member where address = 'Waterbury'