Database: manufacturer
Question: Which manufacturer has the most number of shops? List its name and year of opening.
SQL:
SELECT open_year ,  name FROM manufacturer ORDER BY num_of_shops DESC LIMIT 1