How many departments are in each school?
select count(distinct dept_name), school_code from department group by school_code