how many cities were affected?
select sum ( number_city_affected ) from affected_region
what are the name for the regions?
select region_name from region
how many number of storms for each region?
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