How many classes are held in each department?
select count(*), dept_code from class as t1 join course as t2 on t1.crs_code = t2.crs_code group by dept_code