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)
CREATE TABLE furniture (Furniture_ID NUMBER, Name CLOB, Num_of_Component NUMBER, Market_Rate FLOAT)

Show all manufacturer names and ids with a bar chart, note that let manufacturer id as Y-axis.
SELECT Name, Manufacturer_ID FROM manufacturer ORDER BY Open_Year
SELECT "Name", "Manufacturer_ID" FROM "manufacturer" ORDER BY "Open_Year"