SELECT Name FROM people WHERE People_id NOT IN (SELECT Affirmative FROM debate_people)
List the names of people that have not been on the affirmative side of debates.
SELECT Name FROM people WHERE People_id NOT IN ( SELECT Affirmative FROM debate_people )
select name from people where people_id not in ( select affirmative from debate_people )
List the names of people that have not been on the affirmative side of debates .