CREATE TABLE employment (Company_ID INT, People_ID INT, Year_working INT)
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)

How many companies are there in each headquarters? Return a stacked bar chart to group by industry and headquearters, and count by headquarters, and rank X from high to low order.
SELECT Headquarters, COUNT(Headquarters) FROM company GROUP BY Industry, Headquarters ORDER BY Headquarters DESC
SELECT "Headquarters", COUNT("Headquarters") FROM "company" GROUP BY "Industry", "Headquarters" ORDER BY "Headquarters" DESC NULLS LAST