SCHEMA:
CREATE TABLE member (Membership_card VARCHAR)
USER:
How many members have the black membership card?

QUERY:
SELECT COUNT(*) FROM member WHERE Membership_card = 'Black'