human
Schema:
storm (Storm_ID, Name, Dates_active, Max_speed, Damage_millions_USD, Number_Deaths)
region (Region_id, Region_code, Region_name)
affected_region (Region_id, Storm_ID, Number_city_affected)
Please answer with SQL.
assistant
Sure, I understand.
human
What are the names of the regions affected?
assistant
SELECT region_name FROM region WHERE region_id IN ( SELECT region_id FROM affected_region ) ;
human
How many are there?
assistant
SELECT COUNT( region_name ) FROM region WHERE region_id IN ( SELECT region_id FROM affected_region ) ;