CREATE TABLE furniture (furniture_id NUMBER, name CLOB, num_of_component NUMBER, market_rate NUMBER)
CREATE TABLE manufacturer (manufacturer_id NUMBER, open_year NUMBER, name CLOB, num_of_factories NUMBER, num_of_shops NUMBER)
CREATE TABLE furniture_manufacte (manufacturer_id NUMBER, furniture_id NUMBER, price_in_dollar NUMBER)

List all manufacturer names and ids ordered by their opening year.
SELECT name, manufacturer_id FROM manufacturer ORDER BY open_year
SELECT "name", "manufacturer_id" FROM "manufacturer" ORDER BY "open_year"