Tell me all the cities and their respective stores.
select t1.headquartered_city, t3.store_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
How many stores are there for each city?
select t1.headquartered_city, count(*) 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 group by t1.headquartered_city
Which city has the least number of stores?
select t3.headquartered_city 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 group by t3.headquartered_city order by count(*) asc limit 1
What about the one with the most?
select t3.headquartered_city 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 group by t3.headquartered_city order by count(*) desc limit 1