List all headquarters and the number of companies in each headquarter.
CREATE TABLE company (headquarters VARCHAR)
SELECT headquarters, COUNT(*) FROM company GROUP BY headquarters
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE company (headquarters VARCHAR) Question: List all headquarters and the number of companies in each headquarter. [/INST] SELECT headquarters, COUNT(*) FROM company GROUP BY headquarters </s>