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