SELECT count(*) ,  semester ,  YEAR FROM SECTION GROUP BY semester ,  YEAR
Find the number of courses provided in each semester and year.
SELECT count ( * ) , semester , YEAR FROM SECTION GROUP BY semester , YEAR
select count ( * ) , semester , year from section group by semester , year
Find the number of courses provided in each semester and year .