A bar chart showing the number of debates in each venue for those on the affirmative side, I want to list X-axis in asc order.
CREATE TABLE people (
    People_ID int,
    District text,
    Name text,
    Party text,
    Age int
)

CREATE TABLE debate_people (
    Debate_ID int,
    Affirmative int,
    Negative int,
    If_Affirmative_Win bool
)

CREATE TABLE debate (
    Debate_ID int,
    Date text,
    Venue text,
    Num_of_Audience int
)
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 Venue
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: A bar chart showing the number of debates in each venue for those on the affirmative side, I want to list X-axis in asc order. ### Input: CREATE TABLE people (
    People_ID int,
    District text,
    Name text,
    Party text,
    Age int
)

CREATE TABLE debate_people (
    Debate_ID int,
    Affirmative int,
    Negative int,
    If_Affirmative_Win bool
)

CREATE TABLE debate (
    Debate_ID int,
    Date text,
    Venue text,
    Num_of_Audience int
) ### Response: 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 Venue