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
manufacturer with the most number of shops refers to MAX(num_of_shops); list its name refers to SELECT name; year of opening refers to SELECT open_year;