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

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