CREATE TABLE furniture (furniture_id DECIMAL, name TEXT, num_of_component DECIMAL, market_rate DECIMAL)
CREATE TABLE manufacturer (manufacturer_id DECIMAL, open_year DECIMAL, name TEXT, num_of_factories DECIMAL, num_of_shops DECIMAL)
CREATE TABLE furniture_manufacte (manufacturer_id DECIMAL, furniture_id DECIMAL, price_in_dollar DECIMAL)

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
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"