What are the different school codes?
select distinct school_code from department
For each one, how many different departments does it have?
select count(distinct dept_name), school_code from department group by school_code