A pie chart for listing the number of the venues of debates in ascending order of the number of audience.
CREATE TABLE debate_people (
    Debate_ID int,
    Affirmative int,
    Negative int,
    If_Affirmative_Win bool
)

CREATE TABLE people (
    People_ID int,
    District text,
    Name text,
    Party text,
    Age int
)

CREATE TABLE debate (
    Debate_ID int,
    Date text,
    Venue text,
    Num_of_Audience int
)
SELECT Venue, COUNT(Venue) FROM debate GROUP BY Venue ORDER BY Num_of_Audience
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 pie chart for listing the number of the venues of debates in ascending order of the number of audience. ### Input: CREATE TABLE debate_people (
    Debate_ID int,
    Affirmative int,
    Negative int,
    If_Affirmative_Win bool
)

CREATE TABLE people (
    People_ID int,
    District text,
    Name text,
    Party text,
    Age int
)

CREATE TABLE debate (
    Debate_ID int,
    Date text,
    Venue text,
    Num_of_Audience int
) ### Response: SELECT Venue, COUNT(Venue) FROM debate GROUP BY Venue ORDER BY Num_of_Audience