Schema: CREATE TABLE SECTION (semester VARCHAR, YEAR VARCHAR)
Question: Find the number of courses provided in each semester and year.
SQL: SELECT COUNT(*), semester, YEAR FROM SECTION GROUP BY semester, YEAR