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

Return the names and locations of shops, ordered by name in alphabetical order.
SELECT shop_name, location FROM shop ORDER BY shop_name
SELECT "shop_name", "location" FROM "shop" ORDER BY "shop_name" NULLS FIRST