Indicar as plataformas de software dos dispositivos em ordem decrescente da contagem.
CREATE TABLE device (Software_Platform VARCHAR)
SELECT Software_Platform FROM device GROUP BY Software_Platform ORDER BY COUNT(*) DESC