CREATE TABLE debate (debate_id DECIMAL, date TEXT, venue TEXT, num_of_audience DECIMAL)
CREATE TABLE people (people_id DECIMAL, district TEXT, name TEXT, party TEXT, age DECIMAL)
CREATE TABLE debate_people (debate_id DECIMAL, affirmative DECIMAL, negative DECIMAL, 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"