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

Bar graph to show the total number from different party
SELECT Party, COUNT(*) FROM people GROUP BY Party
SELECT "Party", COUNT(*) FROM "people" GROUP BY "Party"