Database: device
Question: What are the carriers of devices that are not in stock anywhere?
SQL:
SELECT Carrier FROM device WHERE Device_ID NOT IN (SELECT Device_ID FROM stock)