List the name of ships that are not involved in any mission
CREATE TABLE mission (Name VARCHAR, Ship_ID VARCHAR); CREATE TABLE ship (Name VARCHAR, Ship_ID VARCHAR)
SELECT Name FROM ship WHERE NOT Ship_ID IN (SELECT Ship_ID FROM mission)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE mission (Name VARCHAR, Ship_ID VARCHAR); CREATE TABLE ship (Name VARCHAR, Ship_ID VARCHAR) Question: List the name of ships that are not involved in any mission [/INST] SELECT Name FROM ship WHERE NOT Ship_ID IN (SELECT Ship_ID FROM mission) </s>