What are the different school codes?
select distinct school_code from department
How many classes are there for each of them?
select count(*), t3.school_code from class as t1 join course as t2 on t1.crs_code = t2.crs_code join department as t3 on t2.dept_code = t3.dept_code group by t3.school_code