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

How many storms occured in each region. Visualize by bar chart.
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" "T1" JOIN "affected_region" "T2" ON "T1"."Region_id" = "T2"."Region_id" GROUP BY "T1"."Region_id"