List the names of people that have not been on the affirmative side of debates.
CREATE TABLE debate_people (
    debate_id number,
    affirmative number,
    negative number,
    if_affirmative_win others
)

CREATE TABLE debate (
    debate_id number,
    date text,
    venue text,
    num_of_audience number
)

CREATE TABLE people (
    people_id number,
    district text,
    name text,
    party text,
    age number
)
SELECT name FROM people WHERE NOT people_id IN (SELECT affirmative FROM debate_people)
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: List the names of people that have not been on the affirmative side of debates. ### Input: CREATE TABLE debate_people (
    debate_id number,
    affirmative number,
    negative number,
    if_affirmative_win others
)

CREATE TABLE debate (
    debate_id number,
    date text,
    venue text,
    num_of_audience number
)

CREATE TABLE people (
    people_id number,
    district text,
    name text,
    party text,
    age number
) ### Response: SELECT name FROM people WHERE NOT people_id IN (SELECT affirmative FROM debate_people)