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)
CREATE TABLE people (People_ID NUMBER, District CLOB, Name CLOB, Party CLOB, Age NUMBER)

Bar graph to show the total number from different party, rank by the x-axis in descending.
SELECT Party, COUNT(*) FROM people GROUP BY Party ORDER BY Party DESC
SELECT "Party", COUNT(*) FROM "people" GROUP BY "Party" ORDER BY "Party" DESC