What are all the names of the people?
select name from people
What are the names of the people who are in the affirmative side?
select t3.name from debate_people as t1 join debate as t2 on t1.debate_id = t2.debate_id join people as t3 on t1.affirmative = t3.people_id
What are the venues of debates on the affirmative side?
select t2.venue from debate_people as t1 join debate as t2 on t1.debate_id = t2.debate_id join people as t3 on t1.affirmative = t3.people_id
What are the dates of the debates on the affirmative side?
select t2.date from debate_people as t1 join debate as t2 on t1.debate_id = t2.debate_id join people as t3 on t1.affirmative = t3.people_id