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