SCHEMA:
CREATE TABLE branch (city VARCHAR, open_year INTEGER)
USER:
Show the city and the number of branches opened before 2010 for each city.

QUERY:
SELECT city, COUNT(*) FROM branch WHERE open_year < 2010 GROUP BY city