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 FLOAT)
CREATE TABLE storm (Storm_ID INT, Name TEXT, Dates_active TEXT, Max_speed INT, Damage_millions_USD FLOAT, Number_Deaths INT)

Give the proportion of how many storms occured in each region?
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
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"