CREATE TABLE stock (Device_ID VARCHAR2, Shop_ID VARCHAR2)
CREATE TABLE device (Carrier VARCHAR2, Device_ID VARCHAR2)
CREATE TABLE shop (Shop_Name VARCHAR2, Shop_ID VARCHAR2)

Show names of shops and the carriers of devices they have in stock.
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"