Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE debate_people (Name VARCHAR, People_id VARCHAR, Affirmative VARCHAR)
TABLE: 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.

### Accurate SQL ###

SELECT Name FROM people WHERE NOT People_id IN (SELECT Affirmative FROM debate_people)