CREATE TABLE debate_people (Affirmative VARCHAR2)
CREATE TABLE people (Name VARCHAR2, People_ID VARCHAR2)

Show the names of people and the number of times they have been on the affirmative side of debates.
SELECT T2.Name, COUNT(*) FROM debate_people AS T1 JOIN people AS T2 ON T1.Affirmative = T2.People_ID GROUP BY T2.Name
SELECT "T2"."Name", COUNT(*) FROM "debate_people" "T1" JOIN "people" "T2" ON "T1"."Affirmative" = "T2"."People_ID" GROUP BY "T2"."Name"