CREATE TABLE company (company_id NUMBER, name CLOB, headquarters CLOB, industry CLOB, sales_in_billion NUMBER, profits_in_billion NUMBER, assets_in_billion NUMBER, market_value_in_billion NUMBER)
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)

Show the different headquarters and number of companies at each headquarter.
SELECT headquarters, COUNT(*) FROM company GROUP BY headquarters
SELECT "headquarters", COUNT(*) FROM "company" GROUP BY "headquarters"