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

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"