CREATE TABLE furniture (Furniture_ID INT, Name TEXT, Num_of_Component INT, Market_Rate FLOAT)
CREATE TABLE furniture_manufacte (Manufacturer_ID INT, Furniture_ID INT, Price_in_Dollar 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 show by the Y-axis in ascending.
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 COUNT(*)
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 COUNT(*) NULLS FIRST