Show different parties of people along with the number of people in each party by a pie chart.
CREATE TABLE debate_people (
    Debate_ID int,
    Affirmative int,
    Negative int,
    If_Affirmative_Win bool
)

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
)
SELECT Party, COUNT(*) FROM people GROUP BY Party
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 by a pie chart. ### Input: CREATE TABLE debate_people (
    Debate_ID int,
    Affirmative int,
    Negative int,
    If_Affirmative_Win bool
)

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
) ### Response: SELECT Party, COUNT(*) FROM people GROUP BY Party