SELECT count(*) ,  semester ,  YEAR FROM SECTION GROUP BY semester ,  YEAR
How many courses are 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
How many courses are provided in each semester and year ?