What are the names of the districts?
select district_name from district
Tell me which of these districts have stores.
select distinct t1.district_name from district as t1 join store_district as t2 on t1.district_id = t2.district_id join store as t3 on t3.store_id = t2.store_id
What are the store names of the Hafizabad District?
select t1.store_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 t3.district_name = "Hafizabad District"
What about the store names of the Khanewal District?
select t1.store_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 t3.district_name = "Khanewal District"