Database: shop_membership
Question: Show all city with a branch opened in 2001 and a branch with more than 100 membership.
SQL:
SELECT city FROM branch WHERE open_year  =  2001 AND membership_amount  >  100