Task: Text to Code
Input (English): SQL: SELECT Count ( * ) , Headquartered_City FROM district GROUP BY Headquartered_City
Feedback: Need to count total stores for every city .
Output (English): 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