Database: device
Question: What are the different software platforms for devices, ordered by frequency descending?
SQL:
SELECT Software_Platform FROM device GROUP BY Software_Platform ORDER BY COUNT(*) DESC