Show the name for regions and the number of storms for each region, rank in descending by the bars.
CREATE TABLE region (
    Region_id int,
    Region_code text,
    Region_name text
)

CREATE TABLE affected_region (
    Region_id int,
    Storm_ID int,
    Number_city_affected real
)

CREATE TABLE storm (
    Storm_ID int,
    Name text,
    Dates_active text,
    Max_speed int,
    Damage_millions_USD real,
    Number_Deaths int
)
SELECT Region_name, COUNT(*) FROM region AS T1 JOIN affected_region AS T2 ON T1.Region_id = T2.Region_id GROUP BY T1.Region_id ORDER BY Region_name 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 for regions and the number of storms for each region, rank in descending by the bars. ### Input: CREATE TABLE region (
    Region_id int,
    Region_code text,
    Region_name text
)

CREATE TABLE affected_region (
    Region_id int,
    Storm_ID int,
    Number_city_affected real
)

CREATE TABLE storm (
    Storm_ID int,
    Name text,
    Dates_active text,
    Max_speed int,
    Damage_millions_USD real,
    Number_Deaths int
) ### Response: SELECT Region_name, COUNT(*) FROM region AS T1 JOIN affected_region AS T2 ON T1.Region_id = T2.Region_id GROUP BY T1.Region_id ORDER BY Region_name DESC