Show all the software platforms
select software_platform from device
How many for each?
select software_platform, count(*) from device group by software_platform