Show all in the information about devices.
select * from device
What are the unique software platforms
select distinct software_platform from device
How many are there?
select count(distinct software_platform) from device