CREATE TABLE affected_region (region_id NUMBER, storm_id NUMBER, number_city_affected NUMBER)
CREATE TABLE storm (storm_id NUMBER, name CLOB, dates_active CLOB, max_speed NUMBER, damage_millions_usd NUMBER, number_deaths NUMBER)
CREATE TABLE region (region_id NUMBER, region_code CLOB, region_name CLOB)

What are the names of the storms that affected both the regions of Afghanistan and Albania?
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'
SELECT "T3"."name" FROM "affected_region" "T1" JOIN "region" "T2" ON "T1"."region_id" = "T2"."region_id" AND "T2"."region_name" = 'Afghanistan' JOIN "storm" "T3" ON "T1"."storm_id" = "T3"."storm_id" INTERSECT SELECT "T3"."name" FROM "affected_region" "T1" JOIN "region" "T2" ON "T1"."region_id" = "T2"."region_id" AND "T2"."region_name" = 'Albania' JOIN "storm" "T3" ON "T1"."storm_id" = "T3"."storm_id"