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

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" "t1" JOIN "furniture_manufacte" "t2" ON "t1"."Manufacturer_ID" = "t2"."Manufacturer_ID" GROUP BY "t1"."Manufacturer_ID" ORDER BY COUNT(*)