how many products are in the record?
select count(*) from products
find the number for each manufacturer, showing the name of each company.
select count(*), t2.name from products as t1 join manufacturers as t2 on t1.manufacturer = t2.code group by t2.name