CREATE TABLE furniture_manufacte (Manufacturer_ID NUMBER, Furniture_ID NUMBER, Price_in_Dollar FLOAT)
CREATE TABLE furniture (Furniture_ID NUMBER, Name CLOB, Num_of_Component NUMBER, Market_Rate 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 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" "t1" JOIN "furniture_manufacte" "t2" ON "t1"."Manufacturer_ID" = "t2"."Manufacturer_ID" GROUP BY "t1"."Manufacturer_ID" ORDER BY "Name"