CREATE TABLE district (headquartered_city VARCHAR(255), district_id VARCHAR(255)); CREATE TABLE store_district (store_id VARCHAR(255), district_id VARCHAR(255)); CREATE TABLE store (store_id VARCHAR(255))
Find the number of stores in each city.
    
SQL: SELECT t3.headquartered_city, COUNT(*) 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