Please show the different record companies and the corresponding number of orchestras.
CREATE TABLE orchestra (Record_Company VARCHAR)
SELECT Record_Company, COUNT(*) FROM orchestra GROUP BY Record_Company
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE orchestra (Record_Company VARCHAR) Question: Please show the different record companies and the corresponding number of orchestras. [/INST] SELECT Record_Company, COUNT(*) FROM orchestra GROUP BY Record_Company </s>