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 BOOLEAN)
CREATE TABLE debate (Debate_ID INT, Date TEXT, Venue TEXT, Num_of_Audience INT)

Bar chart x axis venue y axis how many venue, display y-axis from low to high order.
SELECT Venue, COUNT(Venue) FROM debate GROUP BY Venue ORDER BY COUNT(Venue)
SELECT "Venue", COUNT("Venue") FROM "debate" GROUP BY "Venue" ORDER BY COUNT("Venue") NULLS FIRST