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

A bar chart about what are the different software platforms for devices, and how many devices have each?, and rank by the the total number from low to high.
SELECT Software_Platform, COUNT(*) FROM device GROUP BY Software_Platform ORDER BY COUNT(*)
SELECT "Software_Platform", COUNT(*) FROM "device" GROUP BY "Software_Platform" ORDER BY COUNT(*)