List the names of people that have not been on the affirmative side of debates.
CREATE TABLE debate_people (Name VARCHAR, People_id VARCHAR, Affirmative VARCHAR); CREATE TABLE people (Name VARCHAR, People_id VARCHAR, Affirmative VARCHAR)
SELECT Name FROM people WHERE NOT People_id IN (SELECT Affirmative FROM debate_people)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE debate_people (Name VARCHAR, People_id VARCHAR, Affirmative VARCHAR); CREATE TABLE people (Name VARCHAR, People_id VARCHAR, Affirmative VARCHAR) Question: List the names of people that have not been on the affirmative side of debates. [/INST] SELECT Name FROM people WHERE NOT People_id IN (SELECT Affirmative FROM debate_people) </s>