How many different denominations does each school have?
select count(distinct denomination) from school;
What are they?
select distinct denomination from school;
How many schools are there for every denomination. Show Denomination and number of schools.
select denomination, count(*) from school group by denomination
Show the results in descending order!
select denomination, count(*) from school group by denomination order by count(*) desc;