Show name, address road, and city for all branches sorted by open year.
CREATE TABLE branch (name VARCHAR, address_road VARCHAR, city VARCHAR, open_year VARCHAR)
SELECT name, address_road, city FROM branch ORDER BY open_year
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE branch (name VARCHAR, address_road VARCHAR, city VARCHAR, open_year VARCHAR) Question: Show name, address road, and city for all branches sorted by open year. [/INST] SELECT name, address_road, city FROM branch ORDER BY open_year </s>