Show the city and the number of branches opened before 2010 for each city.
CREATE TABLE branch (city VARCHAR, open_year INTEGER)
SELECT city, COUNT(*) FROM branch WHERE open_year < 2010 GROUP BY city
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE branch (city VARCHAR, open_year INTEGER) Question: Show the city and the number of branches opened before 2010 for each city. [/INST] SELECT city, COUNT(*) FROM branch WHERE open_year < 2010 GROUP BY city </s>