How many classes exist for each school?
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