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.
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 bool
)
SELECT Party, COUNT(*) FROM people GROUP BY Party ORDER BY COUNT(*) DESC
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: 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. ### Input: 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 bool
) ### Response: SELECT Party, COUNT(*) FROM people GROUP BY Party ORDER BY COUNT(*) DESC