Show the name of each party and the corresponding number of delegates from that party with a bar chart, I want to order in desc by the bars.
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 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
)
SELECT T2.Party, SUM(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: Show the name of each party and the corresponding number of delegates from that party with a bar chart, I want to order in desc by the bars. ### Input: 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 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
) ### Response: SELECT T2.Party, SUM(COUNT(*)) FROM election AS T1 JOIN party AS T2 ON T1.Party = T2.Party_ID GROUP BY T2.Party ORDER BY T2.Party DESC