Show the shop addresses ordered by their opening year.
CREATE TABLE member (
    member_id number,
    name text,
    membership_card text,
    age number,
    time_of_purchase number,
    level_of_membership number,
    address text
)

CREATE TABLE happy_hour (
    hh_id number,
    shop_id number,
    month text,
    num_of_shaff_in_charge number
)

CREATE TABLE happy_hour_member (
    hh_id number,
    member_id number,
    total_amount number
)

CREATE TABLE shop (
    shop_id number,
    address text,
    num_of_staff text,
    score number,
    open_year text
)
SELECT address FROM shop ORDER BY open_year
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Show the shop addresses ordered by their opening year. ### Input: CREATE TABLE member (
    member_id number,
    name text,
    membership_card text,
    age number,
    time_of_purchase number,
    level_of_membership number,
    address text
)

CREATE TABLE happy_hour (
    hh_id number,
    shop_id number,
    month text,
    num_of_shaff_in_charge number
)

CREATE TABLE happy_hour_member (
    hh_id number,
    member_id number,
    total_amount number
)

CREATE TABLE shop (
    shop_id number,
    address text,
    num_of_staff text,
    score number,
    open_year text
) ### Response: SELECT address FROM shop ORDER BY open_year