Show all the software platforms
select software_platform from device
How many device for each?
select software_platform, count(*) from device group by software_platform
Order the software platforms by popularity, from the most to the least?
select software_platform from device group by software_platform order by count(*) desc