List the names of people that are not employed by any company
CREATE TABLE employment (Name VARCHAR, People_ID VARCHAR); CREATE TABLE people (Name VARCHAR, People_ID VARCHAR)
SELECT Name FROM people WHERE NOT People_ID IN (SELECT People_ID FROM employment)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE employment (Name VARCHAR, People_ID VARCHAR); CREATE TABLE people (Name VARCHAR, People_ID VARCHAR) Question: List the names of people that are not employed by any company [/INST] SELECT Name FROM people WHERE NOT People_ID IN (SELECT People_ID FROM employment) </s>