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 could you show in desc by the how many headquarters?
SELECT Headquarters, COUNT(Headquarters) FROM company GROUP BY Industry, Headquarters ORDER BY COUNT(Headquarters) DESC
SELECT "Headquarters", COUNT("Headquarters") FROM "company" GROUP BY "Industry", "Headquarters" ORDER BY COUNT("Headquarters") DESC NULLS LAST