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

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" NULLS FIRST