CREATE TABLE shop (Shop_Name VARCHAR(255), Shop_ID VARCHAR(255)); CREATE TABLE stock (Device_ID VARCHAR(255), Shop_ID VARCHAR(255)); CREATE TABLE device (Carrier VARCHAR(255), Device_ID VARCHAR(255))
Show names of shops and the carriers of devices they have in stock.
    
SQL: 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