How many classes are offered?
select count(*) from class
return the number for 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