CREATE TABLE company (Company_ID FLOAT, Name TEXT, Headquarters TEXT, Industry TEXT, Sales_in_Billion FLOAT, Profits_in_Billion FLOAT, Assets_in_Billion FLOAT, Market_Value_in_Billion FLOAT)
CREATE TABLE people (People_ID INT, Age INT, Name TEXT, Nationality TEXT, Graduation_College TEXT)
CREATE TABLE employment (Company_ID INT, People_ID INT, Year_working INT)

How many companies are there in each headquarters? Return a stacked bar chart to group by industry and headquearters, and count by headquarters, and I want to sort from low to high by the y-axis.
SELECT Headquarters, COUNT(Headquarters) FROM company GROUP BY Industry, Headquarters ORDER BY COUNT(Headquarters)
SELECT "Headquarters", COUNT("Headquarters") FROM "company" GROUP BY "Industry", "Headquarters" ORDER BY COUNT("Headquarters") NULLS FIRST