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)
CREATE TABLE debate_people (debate_id NUMBER, affirmative NUMBER, negative NUMBER, if_affirmative_win others)

Show different parties of people along with the number of people in each party.
SELECT party, COUNT(*) FROM people GROUP BY party
SELECT "party", COUNT(*) FROM "people" GROUP BY "party"