Database: device
Question: What are the different software platforms for devices, and how many devices have each?
SQL:
SELECT Software_Platform ,  COUNT(*) FROM device GROUP BY Software_Platform