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

What campus has the most degrees conferrred over its entire existence?
SELECT campus FROM degrees GROUP BY campus ORDER BY SUM(degrees) DESC LIMIT 1
SELECT "campus" FROM "degrees" GROUP BY "campus" ORDER BY SUM("degrees") DESC FETCH FIRST 1 ROWS ONLY