How many people have been on the negative side?
select count(*) from debate_people as t1 join people as t2 on t1.negative = t2.people_id
How about the affirmative side?
select count(*) from debate_people as t1 join people as t2 on t1.affirmative = t2.people_id
Please give their full names.
select t2.name from debate_people as t1 join people as t2 on t1.affirmative = t2.people_id
Please also show the dates and venues of debates.
select t3.name, t2.date, 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