Show the names of people and the number of times they have been on the affirmative side of debates.
create table people (name varchar, people_id varchar, PRIMARY KEY (name)); create table debate_people (affirmative varchar, PRIMARY KEY (affirmative))
select t2.name, count(*) from debate_people as t1 join people as t2 on t1.affirmative = t2.people_id group by t2.name