CREATE TABLE furniture_manufacte (Manufacturer_ID INT, Furniture_ID INT, Price_in_Dollar FLOAT)
CREATE TABLE furniture (Furniture_ID INT, Name TEXT, Num_of_Component INT, Market_Rate FLOAT)
CREATE TABLE manufacturer (Manufacturer_ID INT, Open_Year FLOAT, Name TEXT, Num_of_Factories INT, Num_of_Shops INT)

Find the number of funiture types produced by each manufacturer as well as the company names Show bar chart, and list in ascending by the names please.
SELECT Name, COUNT(*) FROM manufacturer AS t1 JOIN furniture_manufacte AS t2 ON t1.Manufacturer_ID = t2.Manufacturer_ID GROUP BY t1.Manufacturer_ID ORDER BY Name
SELECT "Name", COUNT(*) FROM "manufacturer" AS "t1" JOIN "furniture_manufacte" AS "t2" ON "t1"."Manufacturer_ID" = "t2"."Manufacturer_ID" GROUP BY "t1"."Manufacturer_ID" ORDER BY "Name" NULLS FIRST