Visualize a pie chart with how many events are there for each party?
CREATE TABLE party (
    Party_ID int,
    Minister text,
    Took_office text,
    Left_office text,
    Region_ID int,
    Party_name text
)

CREATE TABLE member (
    Member_ID int,
    Member_Name text,
    Party_ID text,
    In_office text
)

CREATE TABLE party_events (
    Event_ID int,
    Event_Name text,
    Party_ID int,
    Member_in_charge_ID int
)

CREATE TABLE region (
    Region_ID int,
    Region_name text,
    Date text,
    Label text,
    Format text,
    Catalogue text
)
SELECT Party_name, COUNT(*) FROM party_events AS T1 JOIN party AS T2 ON T1.Party_ID = T2.Party_ID GROUP BY T1.Party_ID
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: Visualize a pie chart with how many events are there for each party? ### Input: CREATE TABLE party (
    Party_ID int,
    Minister text,
    Took_office text,
    Left_office text,
    Region_ID int,
    Party_name text
)

CREATE TABLE member (
    Member_ID int,
    Member_Name text,
    Party_ID text,
    In_office text
)

CREATE TABLE party_events (
    Event_ID int,
    Event_Name text,
    Party_ID int,
    Member_in_charge_ID int
)

CREATE TABLE region (
    Region_ID int,
    Region_name text,
    Date text,
    Label text,
    Format text,
    Catalogue text
) ### Response: SELECT Party_name, COUNT(*) FROM party_events AS T1 JOIN party AS T2 ON T1.Party_ID = T2.Party_ID GROUP BY T1.Party_ID