How many different manufacturers are there?
select count(*) from manufacturer
How many of them have fewer than 10 factories?
select count(*) from manufacturer where num_of_shops < 10
Show their names and the years they opened.
select name, open_year from manufacturer where num_of_shops < 10
Also include those that have more than 10 shops.
select name, open_year from manufacturer where num_of_shops < 10 or num_of_shops > 10