SELECT Denomination ,  COUNT(*) FROM school GROUP BY Denomination ORDER BY COUNT(*) DESC
Please show different denominations and the corresponding number of schools in descending order.
SELECT Denomination , COUNT ( * ) FROM school GROUP BY Denomination ORDER BY COUNT ( * ) DESC
select denomination , count ( * ) from school group by denomination order by count ( * ) desc
Please show different denominations and the corresponding number of schools in descending order .