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)
CREATE TABLE debate_people (Debate_ID INT, Affirmative INT, Negative INT, If_Affirmative_Win BOOLEAN)

A bar chart showing how many debates are held for each venue, order in ascending by the x axis.
SELECT Venue, COUNT(Venue) FROM debate GROUP BY Venue ORDER BY Venue
SELECT "Venue", COUNT("Venue") FROM "debate" GROUP BY "Venue" ORDER BY "Venue" NULLS FIRST