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

How many debates are held for each venue? Show a pie chart.
SELECT Venue, COUNT(Venue) FROM debate GROUP BY Venue
SELECT "Venue", COUNT("Venue") FROM "debate" GROUP BY "Venue"