List all headquarters and the number of companies in each headquarter.
CREATE TABLE company (headquarters VARCHAR)
SELECT headquarters, COUNT(*) FROM company GROUP BY headquarters
### Context: CREATE TABLE company (headquarters VARCHAR) ### Question: List all headquarters and the number of companies in each headquarter. ### Answer: SELECT headquarters, COUNT(*) FROM company GROUP BY headquarters