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

Show the number of debates for each person on the affirmative side in a pie chart.
SELECT Name, COUNT(Name) FROM debate_people AS T1 JOIN debate AS T2 ON T1.Debate_ID = T2.Debate_ID JOIN people AS T3 ON T1.Affirmative = T3.People_ID GROUP BY Name
SELECT "Name", COUNT("Name") FROM "debate_people" "T1" JOIN "debate" "T2" ON "T1"."Debate_ID" = "T2"."Debate_ID" JOIN "people" "T3" ON "T1"."Affirmative" = "T3"."People_ID" GROUP BY "Name"