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 BOOLEAN)

Show different parties of people along with the number of people in each party Plot them as bar chart, and show by the the total number in desc.
SELECT Party, COUNT(*) FROM people GROUP BY Party ORDER BY COUNT(*) DESC
SELECT "Party", COUNT(*) FROM "people" GROUP BY "Party" ORDER BY COUNT(*) DESC