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)
[SQL] SELECT name, address_road, city FROM branch ORDER BY open_year [/SQL]