Task: Text to Code
Input (English): Step 1: For each row in store_district table, find corresponding rows in store table and in district table.
Step 2: find District_name of the results of step 1 whose Store_Name equals City Mall.
Step 3: find District_name of the results of step 1 whose Store_Name equals Village Store.
Step 4: show the rows that are in both the results of step 2 and the results of step 3
Output (English): SELECT T2.District_name FROM store AS T1 JOIN district AS T2 JOIN store_district AS T3 ON T1.Store_ID = T3.Store_ID AND T3.District_ID = T2.District_ID WHERE T1.Store_Name = "City Mall" INTERSECT SELECT T2.District_name FROM store AS T1 JOIN district AS T2 JOIN store_district AS T3 ON T1.Store_ID = T3.Store_ID AND T3.District_ID = T2.District_ID WHERE T1.Store_Name = "Village Store"