How many courses are provided in each semester and year?
SELECT count(*) ,  semester ,  YEAR FROM SECTION GROUP BY semester ,  YEAR
number of courses = COUNT(*); provided in each semester and year refers to GROUP BY semester, YEAR;