List the carriers of devices that have no devices in stock.
CREATE TABLE stock (Carrier VARCHAR, Device_ID VARCHAR); CREATE TABLE device (Carrier VARCHAR, Device_ID VARCHAR)
[SQL] SELECT Carrier FROM device WHERE NOT Device_ID IN (SELECT Device_ID FROM stock) [/SQL]