Translate the following question to SQL: Which manufacturer has the most number of shops? List its name and year of opening.

Schema: CREATE TABLE manufacturer (
    Manufacturer_ID INT   PRIMARY KEY,
    Open_Year REAL,
    Name TEXT,
    Num_of_Factories INT,
    Num_of_Shops INT,
    UNIQUE (Manufacturer_ID)
);

CREATE TABLE furniture (
    Furniture_ID INT   PRIMARY KEY,
    Name TEXT,
    Num_of_Component INT,
    Market_Rate REAL,
    UNIQUE (Furniture_ID)
);

CREATE TABLE furniture_manufacte (
    Manufacturer_ID INT   PRIMARY KEY,
    Furniture_ID INT   PRIMARY KEY,
    Price_in_Dollar REAL,
    PRIMARY KEY (Manufacturer_ID, Furniture_ID),
    UNIQUE (Manufacturer_ID, Furniture_ID),
    FOREIGN KEY (Furniture_ID) REFERENCES furniture(Furniture_ID),
    FOREIGN KEY (Manufacturer_ID) REFERENCES manufacturer(Manufacturer_ID)
);
user
SELECT open_year ,  name FROM manufacturer ORDER BY num_of_shops DESC LIMIT 1
assistant