SELECT Software_Platform ,  COUNT(*) FROM device GROUP BY Software_Platform
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
What are the different software platforms for devices , and how many devices have each ?