CREATE TABLE people (People_ID NUMBER, District CLOB, Name CLOB, Party CLOB, Age NUMBER)
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)

A bar chart showing the number of debates in each venue for those on the affirmative side, and rank by the the number of venue in asc.
SELECT Venue, COUNT(Venue) 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 Venue ORDER BY COUNT(Venue)
SELECT "Venue", COUNT("Venue") 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 "Venue" ORDER BY COUNT("Venue")