For each party, return the name of the party and the number of delegates from that party Plot them as bar chart, and sort bar from high to low order.
CREATE TABLE election (
    Election_ID int,
    Counties_Represented text,
    District int,
    Delegate text,
    Party int,
    First_Elected real,
    Committee text
)

CREATE TABLE county (
    County_Id int,
    County_name text,
    Population real,
    Zip_code text
)

CREATE TABLE party (
    Party_ID int,
    Year real,
    Party text,
    Governor text,
    Lieutenant_Governor text,
    Comptroller text,
    Attorney_General text,
    US_Senate text
)
SELECT T2.Party, AVG(COUNT(*)) FROM election AS T1 JOIN party AS T2 ON T1.Party = T2.Party_ID GROUP BY T2.Party ORDER BY T2.Party 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: For each party, return the name of the party and the number of delegates from that party Plot them as bar chart, and sort bar from high to low order. ### Input: CREATE TABLE election (
    Election_ID int,
    Counties_Represented text,
    District int,
    Delegate text,
    Party int,
    First_Elected real,
    Committee text
)

CREATE TABLE county (
    County_Id int,
    County_name text,
    Population real,
    Zip_code text
)

CREATE TABLE party (
    Party_ID int,
    Year real,
    Party text,
    Governor text,
    Lieutenant_Governor text,
    Comptroller text,
    Attorney_General text,
    US_Senate text
) ### Response: SELECT T2.Party, AVG(COUNT(*)) FROM election AS T1 JOIN party AS T2 ON T1.Party = T2.Party_ID GROUP BY T2.Party ORDER BY T2.Party DESC