CREATE TABLE company (headquarters VARCHAR)

List all headquarters and the number of companies in each headquarter.
SELECT headquarters, COUNT(*) FROM company GROUP BY headquarters
SELECT "headquarters", COUNT(*) FROM "company" GROUP BY "headquarters"