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)
CREATE TABLE furniture (furniture_id DECIMAL, name TEXT, num_of_component DECIMAL, market_rate DECIMAL)

Which manufacturer has the most number of shops? List its name and year of opening.
SELECT open_year, name FROM manufacturer ORDER BY num_of_shops DESC LIMIT 1
SELECT "open_year", "name" FROM "manufacturer" ORDER BY "num_of_shops" DESC NULLS LAST LIMIT 1