CREATE TABLE storm (Storm_ID NUMBER, Name CLOB, Dates_active CLOB, Max_speed NUMBER, Damage_millions_USD FLOAT, Number_Deaths NUMBER)
CREATE TABLE region (Region_id NUMBER, Region_code CLOB, Region_name CLOB)
CREATE TABLE affected_region (Region_id NUMBER, Storm_ID NUMBER, Number_city_affected FLOAT)

how many regions were affected by each storm?, I want to order in desc by the y axis.
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 COUNT(*) DESC
SELECT "Name", COUNT(*) FROM "storm" "T1" JOIN "affected_region" "T2" ON "T1"."Storm_ID" = "T2"."Storm_ID" GROUP BY "T1"."Storm_ID" ORDER BY COUNT(*) DESC