CREATE TABLE debate_people (debate_id DECIMAL, affirmative DECIMAL, negative DECIMAL, if_affirmative_win others)
CREATE TABLE debate (debate_id DECIMAL, date TEXT, venue TEXT, num_of_audience DECIMAL)
CREATE TABLE people (people_id DECIMAL, district TEXT, name TEXT, party TEXT, age DECIMAL)

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" AS "T1" JOIN "people" AS "T2" ON "T1"."affirmative" = "T2"."people_id" GROUP BY "T2"."name"