What is the denomination of each school?
select denomination from school;
What are the enrollments of schools whose denomination is "Catholic"?
select enrollment from school where denomination = "Catholic";
How about non-Catholic?
select enrollment from school where denomination != "Catholic";