CREATE TABLE store_district (Store_ID NUMBER, District_ID NUMBER)
CREATE TABLE district (District_ID NUMBER, District_name CLOB, Headquartered_City CLOB, City_Population FLOAT, City_Area FLOAT)
CREATE TABLE product (product_id NUMBER, product CLOB, dimensions CLOB, dpi FLOAT, pages_per_minute_color FLOAT, max_page_size CLOB, interface CLOB)
CREATE TABLE store (Store_ID NUMBER, Store_Name CLOB, Type CLOB, Area_size FLOAT, Number_of_product_category FLOAT, Ranking NUMBER)
CREATE TABLE store_product (Store_ID NUMBER, Product_ID NUMBER)

For each type of store, how many of them are there Plot them as bar chart, and list in ascending by the y-axis.
SELECT Type, COUNT(*) FROM store GROUP BY Type ORDER BY COUNT(*)
SELECT "Type", COUNT(*) FROM "store" GROUP BY "Type" ORDER BY COUNT(*)