human
Schema:
device (Device_ID, Device, Carrier, Package_Version, Applications, Software_Platform)
shop (Shop_ID, Shop_Name, Location, Open_Date, Open_Year)
stock (Shop_ID, Device_ID, Quantity)
Please answer with SQL.
assistant
Sure, I understand.
human
List the software platform shared by the greatest number of devices.
assistant
SELECT Software_Platform FROM device GROUP BY Software_Platform ORDER BY COUNT( * ) DESC LIMIT 1;
human
How many devices from the list use the Android platform?
assistant
SELECT COUNT( * ) FROM device WHERE Software_Platform = 'Android';
human
And how many devices from the list use the iOS platform?
assistant
SELECT COUNT( * ) FROM device WHERE Software_Platform = "iOS" ;