CREATE TABLE debate_people (Debate_ID NUMBER, Affirmative NUMBER, Negative NUMBER, If_Affirmative_Win BOOLEAN)
CREATE TABLE people (People_ID NUMBER, District CLOB, Name CLOB, Party CLOB, Age NUMBER)
CREATE TABLE debate (Debate_ID NUMBER, Date CLOB, Venue CLOB, Num_of_Audience NUMBER)

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