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 )
Could you please tell me their party affiliations?
select party from people where people_id not in ( select affirmative from debate_people )
What are their ages?
select age from people where people_id not in ( select affirmative from debate_people )