Find the ids and names of members who are under age 30
select name, member_id from member where age < 30
Please find the ids and names of members with black membership card.
select name, member_id from member where membership_card = 'Black'
Hmmm. Can you also show me the ids and names of members who are over age 30?
select name, member_id from member where membership_card = 'Black' or age > 30
How many of these members have a black membership card?
select count ( * ) from member where membership_card = 'Black' or age > 30
Can you please show me their names?
select name from member where membership_card = 'Black' or age > 30