Show all the software platforms
select software_platform from device
How many for each?
select software_platform, count(*) from device group by software_platform
Which two are the most popular software platform?
select software_platform from device group by software_platform order by count(*) desc limit 2
What about top 1?
select software_platform from device group by software_platform order by count(*) desc limit 1