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)
SELECT Carrier FROM device WHERE NOT Device_ID IN (SELECT Device_ID FROM stock)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE stock (Carrier VARCHAR, Device_ID VARCHAR); CREATE TABLE device (Carrier VARCHAR, Device_ID VARCHAR) Question: List the carriers of devices that have no devices in stock. [/INST] SELECT Carrier FROM device WHERE NOT Device_ID IN (SELECT Device_ID FROM stock) </s>