SELECT Carrier FROM device WHERE Device_ID NOT IN (SELECT Device_ID FROM stock)
List the carriers of devices that have no devices in stock.
SELECT Carrier FROM device WHERE Device_ID NOT IN ( SELECT Device_ID FROM stock )
select carrier from device where device_id not in ( select device_id from stock )
List the carriers of devices that have no devices in stock .