Task: Text to Code
Input (English): Step 1: For each row in affected_region table, find corresponding rows in storm table and in region table.
Step 2: find Name of the results of step 1 whose Region_code equals Afghanistan.
Step 3: find Name of the results of step 1 whose Region_code equals Albania.
Step 4: show the rows that are in both the results of step 2 and the results of step 3
Output (English): SELECT T1.Name FROM storm AS T1 JOIN region AS T2 JOIN affected_region AS T3 ON T1.Storm_ID = T3.Storm_ID AND T3.Region_id = T2.Region_id WHERE T2.Region_code = "Afghanistan" INTERSECT SELECT T1.Name FROM storm AS T1 JOIN region AS T2 JOIN affected_region AS T3 ON T1.Storm_ID = T3.Storm_ID AND T3.Region_id = T2.Region_id WHERE T2.Region_code = "Albania"