CREATE TABLE shop (shop_id DECIMAL, shop_name TEXT, location TEXT, open_date TEXT, open_year DECIMAL)
CREATE TABLE stock (shop_id DECIMAL, device_id DECIMAL, quantity DECIMAL)
CREATE TABLE device (device_id DECIMAL, device TEXT, carrier TEXT, package_version TEXT, applications TEXT, software_platform TEXT)

What is the software platform that is most common amongst all devices?
SELECT software_platform FROM device GROUP BY software_platform ORDER BY COUNT(*) DESC LIMIT 1
SELECT "software_platform" FROM "device" GROUP BY "software_platform" ORDER BY COUNT(*) DESC NULLS LAST LIMIT 1