Database: storm_record
Question: Show the name for regions and the number of storms for each region.
SQL:
SELECT T1.region_name ,  count(*) FROM region AS T1 JOIN affected_region AS T2 ON T1.region_id = T2.region_id GROUP BY T1.region_id