CREATE TABLE debate_people (Debate_ID INT, Affirmative INT, Negative INT, If_Affirmative_Win BOOLEAN)
CREATE TABLE people (People_ID INT, District TEXT, Name TEXT, Party TEXT, Age INT)
CREATE TABLE debate (Debate_ID INT, Date TEXT, Venue TEXT, Num_of_Audience INT)

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