How many branches have more than 100 memberships?
select count(*) from branch where membership_amount > 100
Give me all cities with any of those branches.
select city from branch where membership_amount > 100
What about cities without any of those branches?
select city from branch except select city from branch where membership_amount > 100