What are the names of the people who have been on the affirmative side of debates?
select t2.name from debate_people as t1 join people as t2 on t1.affirmative = t2.people_id group by t2.name
What are their party affiliations?
select t2.party from debate_people as t1 join people as t2 on t1.affirmative = t2.people_id group by t2.name
How many debates did they win total?
select count ( * ) from debate_people where if_affirmative_win = 'T'