-- Database schema
| manufacturer : Manufacturer_ID [ INT ] primary_key , Open_Year [ INT ] , Name [ TEXT ] , Num_of_Factories [ INT ] , Num_of_Shops [ INT ] | furniture : Furniture_ID [ INT ] primary_key , Name [ TEXT ] , Num_of_Component [ INT ] , Market_Rate [ INT ] | furniture_manufacte : Manufacturer_ID [ INT ] primary_key furniture_manufacte.Manufacturer_ID = manufacturer.Manufacturer_ID , Furniture_ID [ INT ] furniture_manufacte.Furniture_ID = furniture.Furniture_ID , Price_in_Dollar [ INT ] |
-- -- Find the number of funiture types produced by each manufacturer as well as the company names.

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;