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)
CREATE TABLE device (Device_ID INT, Device TEXT, Carrier TEXT, Package_Version TEXT, Applications TEXT, Software_Platform TEXT)

A bar chart about what are the different software platforms for devices, and how many devices have each?, and 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