Could you please tell me the names of the people that have not been on the affirmative side of all debates?
SELECT Name FROM people WHERE People_id NOT IN  ( SELECT Affirmative FROM debate_people ) 
names of people not on the affirmative side of all debates refers to selecting names from a table where their ID does not appear in the subset of IDs that have been on the affirmative side in any of the debates;