SELECT Name, COUNT(*) FROM storm AS T1 JOIN affected_region AS T2 ON T1.Storm_ID = T2.Storm_ID GROUP BY T1.Storm_ID ORDER BY Name
how many regions were affected by each storm?, display x-axis in asc order.
CREATE TABLE storm (
    Storm_ID int,
    Name text,
    Dates_active text,
    Max_speed int,
    Damage_millions_USD real,
    Number_Deaths int
)

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
)