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

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" NULLS FIRST