CREATE TABLE store_district (store_id VARCHAR, district_id VARCHAR)
CREATE TABLE district (District_name VARCHAR, district_id VARCHAR)
CREATE TABLE store (store_id VARCHAR, Type VARCHAR)

Find the names of districts where have both city mall and village store type stores.
SELECT t3.District_name FROM store AS t1 JOIN store_district AS t2 ON t1.store_id = t2.store_id JOIN district AS t3 ON t2.district_id = t3.district_id WHERE t1.Type = "City Mall" INTERSECT SELECT t3.District_name FROM store AS t1 JOIN store_district AS t2 ON t1.store_id = t2.store_id JOIN district AS t3 ON t2.district_id = t3.district_id WHERE t1.Type = "Village Store"
SELECT "t3"."District_name" FROM "store" AS "t1" JOIN "store_district" AS "t2" ON "t1"."store_id" = "t2"."store_id" JOIN "district" AS "t3" ON "t2"."district_id" = "t3"."district_id" WHERE "City Mall" = "t1"."Type" INTERSECT SELECT "t3"."District_name" FROM "store" AS "t1" JOIN "store_district" AS "t2" ON "t1"."store_id" = "t2"."store_id" JOIN "district" AS "t3" ON "t2"."district_id" = "t3"."district_id" WHERE "Village Store" = "t1"."Type"