-- Database schema
| storm : Storm_ID [ INT ] primary_key , Name [ TEXT ] , Dates_active [ TEXT ] , Max_speed [ INT ] , Damage_millions_USD [ INT ] , Number_Deaths [ INT ] | region : Region_id [ INT ] primary_key , Region_code [ TEXT ] , Region_name [ TEXT ] | affected_region : Region_id [ INT ] primary_key affected_region.Region_id = region.Region_id , Storm_ID [ INT ] affected_region.Storm_ID = storm.Storm_ID , Number_city_affected [ INT ] |
-- -- Show storm name with at least two regions and 10 cities affected.

SELECT T1.name FROM storm AS T1 JOIN affected_region AS T2 ON T1.storm_id  =  T2.storm_id GROUP BY T1.storm_id HAVING count(*)  >=  2 INTERSECT SELECT T1.name FROM storm AS T1 JOIN affected_region AS T2 ON T1.storm_id  =  T2.storm_id GROUP BY T1.storm_id HAVING sum(T2.number_city_affected)  >=  10;