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 employment (Company_ID NUMBER, People_ID NUMBER, Year_working NUMBER)
CREATE TABLE people (People_ID NUMBER, Age NUMBER, Name CLOB, Nationality CLOB, Graduation_College CLOB)

How many companies are there in each headquarters? Return a stacked bar chart to group by industry and headquearters, and count by headquarters.
SELECT Headquarters, COUNT(Headquarters) FROM company GROUP BY Industry, Headquarters
SELECT "Headquarters", COUNT("Headquarters") FROM "company" GROUP BY "Industry", "Headquarters"