How many different counties are there?
select count(distinct county) from school
How many schools are there in each county?
select county, count(*) from school group by county
Please also show the total enrollment in each county.
select county, count(*), sum(enrollment) from school group by county