text: Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
  ### Context:
  CREATE TABLE branch (city VARCHAR, open_year INTEGER)
  ### Question:
  Show the city and the number of branches opened before 2010 for each city.
  ### Answer:
  SELECT city, COUNT(*) FROM branch WHERE open_year < 2010 GROUP BY city