What are the different software platforms for devices, and how many devices have each?
SELECT Software_Platform ,  COUNT(*) FROM device GROUP BY Software_Platform
SELECT Software_Platform ,  COUNT(*) FROM device GROUP BY Software_Platform
[{'Software_Platform': 'Android', 'COUNT(*)': 5}, {'Software_Platform': 'iOS', 'COUNT(*)': 1}]