what are the names of people who did not participate in the candidate election.
CREATE TABLE candidate (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 candidate)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE candidate (name VARCHAR, people_id VARCHAR); CREATE TABLE people (name VARCHAR, people_id VARCHAR) Question: what are the names of people who did not participate in the candidate election. [/INST] SELECT name FROM people WHERE NOT people_id IN (SELECT people_id FROM candidate) </s>