CREATE TABLE prereq (course_id VARCHAR2, prereq_id VARCHAR2)
CREATE TABLE section (course_id VARCHAR2, sec_id VARCHAR2, semester VARCHAR2, year NUMBER, building VARCHAR2, room_number VARCHAR2, time_slot_id VARCHAR2)
CREATE TABLE instructor (ID VARCHAR2, name VARCHAR2, dept_name VARCHAR2, salary NUMBER)
CREATE TABLE time_slot (time_slot_id VARCHAR2, day VARCHAR2, start_hr NUMBER, start_min NUMBER, end_hr NUMBER, end_min NUMBER)
CREATE TABLE student (ID VARCHAR2, name VARCHAR2, dept_name VARCHAR2, tot_cred NUMBER)
CREATE TABLE teaches (ID VARCHAR2, course_id VARCHAR2, sec_id VARCHAR2, semester VARCHAR2, year NUMBER)
CREATE TABLE takes (ID VARCHAR2, course_id VARCHAR2, sec_id VARCHAR2, semester VARCHAR2, year NUMBER, grade VARCHAR2)
CREATE TABLE classroom (building VARCHAR2, room_number VARCHAR2, capacity NUMBER)
CREATE TABLE advisor (s_ID VARCHAR2, i_ID VARCHAR2)
CREATE TABLE course (course_id VARCHAR2, title VARCHAR2, dept_name VARCHAR2, credits NUMBER)
CREATE TABLE department (dept_name VARCHAR2, building VARCHAR2, budget NUMBER)

Visualize the general trend of how many courses over the year, and could you show X in asc order please?
SELECT year, COUNT(*) FROM section GROUP BY year ORDER BY year
SELECT "year", COUNT(*) FROM "section" GROUP BY "year" ORDER BY "year"