List all manufacturer names and ids ordered by their opening year.
CREATE TABLE furniture (
    furniture_id number,
    name text,
    num_of_component number,
    market_rate number
)

CREATE TABLE manufacturer (
    manufacturer_id number,
    open_year number,
    name text,
    num_of_factories number,
    num_of_shops number
)

CREATE TABLE furniture_manufacte (
    manufacturer_id number,
    furniture_id number,
    price_in_dollar number
)
SELECT name, manufacturer_id FROM manufacturer 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: List all manufacturer names and ids ordered by their opening year. ### Input: CREATE TABLE furniture (
    furniture_id number,
    name text,
    num_of_component number,
    market_rate number
)

CREATE TABLE manufacturer (
    manufacturer_id number,
    open_year number,
    name text,
    num_of_factories number,
    num_of_shops number
)

CREATE TABLE furniture_manufacte (
    manufacturer_id number,
    furniture_id number,
    price_in_dollar number
) ### Response: SELECT name, manufacturer_id FROM manufacturer ORDER BY open_year