Database: shop_membership
Question: What are the names, address roads, and cities of the branches ordered by opening year?
SQL:
SELECT name ,  address_road ,  city FROM branch ORDER BY open_year