what are different membership cards?
select distinct membership_card from member
how many black ones are there?
select count(*) from member where membership_card = 'Black'
show addresses for those who have one.
select address from member where membership_card = 'Black'
how about those who do not have one?
select address from member except select address from member where membership_card = 'Black'