CREATE TABLE store_district (Store_ID INT, District_ID INT)
CREATE TABLE district (District_ID INT, District_name TEXT, Headquartered_City TEXT, City_Population FLOAT, City_Area FLOAT)
CREATE TABLE store (Store_ID INT, Store_Name TEXT, Type TEXT, Area_size FLOAT, Number_of_product_category FLOAT, Ranking INT)
CREATE TABLE store_product (Store_ID INT, Product_ID INT)
CREATE TABLE product (product_id INT, product TEXT, dimensions TEXT, dpi FLOAT, pages_per_minute_color FLOAT, max_page_size TEXT, interface TEXT)

Return a bar chart on how many stores are headquarted in each city?, and sort in asc by the bars.
SELECT 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 ORDER BY Headquartered_City
SELECT "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" ORDER BY "Headquartered_City" NULLS FIRST