CREATE TABLE discipline_enrollments (campus NUMBER, discipline NUMBER, year NUMBER, undergraduate NUMBER, graduate NUMBER)
CREATE TABLE faculty (campus NUMBER, year NUMBER, faculty NUMBER)
CREATE TABLE campuses (id NUMBER, campus CLOB, location CLOB, county CLOB, year NUMBER)
CREATE TABLE degrees (year NUMBER, campus NUMBER, degrees NUMBER)
CREATE TABLE csu_fees (campus NUMBER, year NUMBER, campusfee NUMBER)
CREATE TABLE enrollments (campus NUMBER, year NUMBER, totalenrollment_ay NUMBER, fte_ay NUMBER)

Which year has the most degrees conferred?
SELECT year FROM degrees GROUP BY year ORDER BY SUM(degrees) DESC LIMIT 1
SELECT "year" FROM "degrees" GROUP BY "year" ORDER BY SUM("degrees") DESC FETCH FIRST 1 ROWS ONLY