Please show each industry and the corresponding number of companies in that industry.
CREATE TABLE Companies (Industry VARCHAR)
SELECT Industry, COUNT(*) FROM Companies GROUP BY Industry
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Companies (Industry VARCHAR) Question: Please show each industry and the corresponding number of companies in that industry. [/INST] SELECT Industry, COUNT(*) FROM Companies GROUP BY Industry </s>