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

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