How many branches were opened in 2001?
select count(*) from branch where open_year = 2001
Among them, how many also have more than 100 membership?
select count(*) from branch where open_year = 2001 and membership_amount > 100
Show me all cities with any of those branches.
select city from branch where open_year = 2001 and membership_amount > 100