SELECT count(*) FROM member WHERE Membership_card  =  'Black'
How many members have the black membership card?
SELECT count ( * ) FROM member WHERE Membership_card = 'Black '
select count ( * ) from member where membership_card = value
How many members have the black membership card ?