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 (name VARCHAR, address_road VARCHAR, city VARCHAR, open_year VARCHAR)
  ### Question:
  Show name, address road, and city for all branches sorted by open year.
  ### Answer:
  SELECT name, address_road, city FROM branch ORDER BY open_year