 Show the name of each party and the corresponding number of delegates from that party in a bar chart.
CREATE TABLE election (
    Election_ID int,
    Counties_Represented text,
    District int,
    Delegate text,
    Party int,
    First_Elected real,
    Committee text
)

CREATE TABLE party (
    Party_ID int,
    Year real,
    Party text,
    Governor text,
    Lieutenant_Governor text,
    Comptroller text,
    Attorney_General text,
    US_Senate text
)

CREATE TABLE county (
    County_Id int,
    County_name text,
    Population real,
    Zip_code text
)
SELECT T2.Party, AVG(COUNT(*)) FROM election AS T1 JOIN party AS T2 ON T1.Party = T2.Party_ID GROUP BY T2.Party