Please show different denominations and the corresponding number of schools in descending order.
CREATE TABLE school (Denomination VARCHAR)
SELECT Denomination, COUNT(*) FROM school GROUP BY Denomination ORDER BY COUNT(*) DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE school (Denomination VARCHAR) Question: Please show different denominations and the corresponding number of schools in descending order. [/INST] SELECT Denomination, COUNT(*) FROM school GROUP BY Denomination ORDER BY COUNT(*) DESC </s>