Database: shop_membership
Question: Show the city and the number of branches opened before 2010 for each city.
SQL:
SELECT city ,  count(*) FROM branch WHERE open_year  <  2010 GROUP BY city