How many courses are offered in each year?
select count(*), year from section group by year
Split these by semester as well.
select count(*), semester, year from section group by semester, year