Find the name of scientists who are not assigned to any project.
CREATE TABLE scientists (Name VARCHAR, ssn VARCHAR, scientist VARCHAR); CREATE TABLE AssignedTo (Name VARCHAR, ssn VARCHAR, scientist VARCHAR)
SELECT Name FROM scientists WHERE NOT ssn IN (SELECT scientist FROM AssignedTo)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE scientists (Name VARCHAR, ssn VARCHAR, scientist VARCHAR); CREATE TABLE AssignedTo (Name VARCHAR, ssn VARCHAR, scientist VARCHAR) Question: Find the name of scientists who are not assigned to any project. [/INST] SELECT Name FROM scientists WHERE NOT ssn IN (SELECT scientist FROM AssignedTo) </s>