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

A bar chart showing how many debates are held for each venue, and list how many venue in descending order.
SELECT Venue, COUNT(Venue) FROM debate GROUP BY Venue ORDER BY COUNT(Venue) DESC
SELECT "Venue", COUNT("Venue") FROM "debate" GROUP BY "Venue" ORDER BY COUNT("Venue") DESC NULLS LAST