Select the project names which are not assigned yet.
CREATE TABLE Projects (Name VARCHAR, Code VARCHAR, Project VARCHAR); CREATE TABLE AssignedTo (Name VARCHAR, Code VARCHAR, Project VARCHAR)
SELECT Name FROM Projects WHERE NOT Code IN (SELECT Project FROM AssignedTo)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Projects (Name VARCHAR, Code VARCHAR, Project VARCHAR); CREATE TABLE AssignedTo (Name VARCHAR, Code VARCHAR, Project VARCHAR) Question: Select the project names which are not assigned yet. [/INST] SELECT Name FROM Projects WHERE NOT Code IN (SELECT Project FROM AssignedTo) </s>