How many distinct manufacturers are there?
select count(distinct manufacturer_id) from manufacturer
How many produce furniture?
select count(distinct t1.manufacturer_id) from manufacturer as t1 join furniture_manufacte as t2 on t1.manufacturer_id = t2.manufacturer_id
What are their names?
select distinct t1.name from manufacturer as t1 join furniture_manufacte as t2 on t1.manufacturer_id = t2.manufacturer_id
Also show how many furniture types each manufacturer produces.
select count(*), t1.name from manufacturer as t1 join furniture_manufacte as t2 on t1.manufacturer_id = t2.manufacturer_id group by t1.manufacturer_id