CREATE TABLE device (Device_ID NUMBER, Device CLOB, Carrier CLOB, Package_Version CLOB, Applications CLOB, Software_Platform CLOB)
CREATE TABLE stock (Shop_ID NUMBER, Device_ID NUMBER, Quantity NUMBER)
CREATE TABLE shop (Shop_ID NUMBER, Shop_Name CLOB, Location CLOB, Open_Date CLOB, Open_Year NUMBER)

Bar chart x axis software platform y axis the total number, I want to show in ascending by the X-axis.
SELECT Software_Platform, COUNT(*) FROM device GROUP BY Software_Platform ORDER BY Software_Platform
SELECT "Software_Platform", COUNT(*) FROM "device" GROUP BY "Software_Platform" ORDER BY "Software_Platform"