Which manufacturer has the most number of shops? List its name and year of opening.
CREATE TABLE manufacturer (open_year VARCHAR, name VARCHAR, num_of_shops VARCHAR)
SELECT TOP 1 open_year, name FROM manufacturer ORDER BY num_of_shops DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE manufacturer (open_year VARCHAR, name VARCHAR, num_of_shops VARCHAR) Question: Which manufacturer has the most number of shops? List its name and year of opening. [/INST] SELECT TOP 1 open_year, name FROM manufacturer ORDER BY num_of_shops DESC </s>