-- 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 ] |
-- -- Find the name of the storm that affected both Afghanistan and Albania regions.

SELECT T3.Name FROM affected_region AS T1 JOIN region AS T2 ON T1.region_id  =  T2.region_id JOIN storm AS T3 ON T1.storm_id  =  T3.storm_id WHERE T2.Region_name  =  'Afghanistan' INTERSECT SELECT T3.Name FROM affected_region AS T1 JOIN region AS T2 ON T1.region_id  =  T2.region_id JOIN storm AS T3 ON T1.storm_id  =  T3.storm_id WHERE T2.Region_name  =  'Albania';