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

Bar graph to show the total number from different party, and rank Y-axis from high to low order.
SELECT Party, COUNT(*) FROM people GROUP BY Party ORDER BY COUNT(*) DESC
SELECT "Party", COUNT(*) FROM "people" GROUP BY "Party" ORDER BY COUNT(*) DESC