Table schema:
CREATE TABLE company (headquarters VARCHAR)

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