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)
CREATE TABLE shop (shop_id NUMBER, shop_name CLOB, location CLOB, open_date CLOB, open_year NUMBER)

What are the names of device shops, and what are the carriers that they carry devices in stock for?
SELECT T3.shop_name, T2.carrier FROM stock AS T1 JOIN device AS T2 ON T1.device_id = T2.device_id JOIN shop AS T3 ON T1.shop_id = T3.shop_id
SELECT "T3"."shop_name", "T2"."carrier" FROM "stock" "T1" JOIN "device" "T2" ON "T1"."device_id" = "T2"."device_id" JOIN "shop" "T3" ON "T1"."shop_id" = "T3"."shop_id"