Database: shop_membership
Question: What are the cities that have a branch that opened in 2001 and a branch with more than 100 members?
SQL:
SELECT city FROM branch WHERE open_year  =  2001 AND membership_amount  >  100