What is the average number of shops for manufacturers?
select avg(num_of_shops) from manufacturer
How about the minimum?
select min(num_of_shops) from manufacturer
Which manufacturer has the fewest shops?
select * from manufacturer order by num_of_shops desc limit 1
Only show the year it opened and the name of the manufacturer.
select open_year, name from manufacturer order by num_of_shops desc limit 1