What are the different software platforms for devices, and how many devices have each, sort in desc by the total number.
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
)

CREATE TABLE stock (
    Shop_ID int,
    Device_ID int,
    Quantity int
)
SELECT Software_Platform, COUNT(*) FROM device GROUP BY Software_Platform ORDER BY COUNT(*) DESC
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What are the different software platforms for devices, and how many devices have each, sort in desc by the total number. ### Input: 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
)

CREATE TABLE stock (
    Shop_ID int,
    Device_ID int,
    Quantity int
) ### Response: SELECT Software_Platform, COUNT(*) FROM device GROUP BY Software_Platform ORDER BY COUNT(*) DESC