List all the carriers
select carrier from device
Show all the unique carriers of the devices in the stock.
select distinct t2.carrier from stock as t1 join device as t2 on t1.device_id = t2.device_id
Which carriers have no devices in stock?
select carrier from device where device_id not in (select device_id from stock)