-- Database schema
| manufacturer : Manufacturer_ID [ INT ] primary_key , Open_Year [ INT ] , Name [ TEXT ] , Num_of_Factories [ INT ] , Num_of_Shops [ INT ] | furniture : Furniture_ID [ INT ] primary_key , Name [ TEXT ] , Num_of_Component [ INT ] , Market_Rate [ INT ] | furniture_manufacte : Manufacturer_ID [ INT ] primary_key furniture_manufacte.Manufacturer_ID = manufacturer.Manufacturer_ID , Furniture_ID [ INT ] furniture_manufacte.Furniture_ID = furniture.Furniture_ID , Price_in_Dollar [ INT ] |
-- -- 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;