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