Could you please tell me their party affiliations?
SELECT Party FROM people WHERE People_id NOT IN  ( SELECT Affirmative FROM debate_people ) 
their party affiliations refers to Party; People not participating in a debate are identified by People_id NOT IN (SELECT Affirmative FROM debate_people);