CREATE TABLE debate_people (Debate_ID NUMBER, Affirmative NUMBER, Negative NUMBER, If_Affirmative_Win BOOLEAN)
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)

Show the names of people and the number of times they have been on the affirmative side of debates by 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" "T1" JOIN "people" "T2" ON "T1"."Affirmative" = "T2"."People_ID" GROUP BY "T2"."Name"