Show names of shops and the carriers of devices they have in stock.
create table shop (shop_name varchar, shop_id varchar, PRIMARY KEY (shop_name)); create table stock (device_id varchar, shop_id varchar, PRIMARY KEY (device_id)); create table device (carrier varchar, device_id varchar, PRIMARY KEY (carrier))
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