Database: shop_membership
Question: Show name, address road, and city for all branches sorted by open year.
SQL:
SELECT name ,  address_road ,  city FROM branch ORDER BY open_year