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

report the total number of degrees granted between 1998 and 2002.
SELECT T1.campus, SUM(T2.degrees) FROM campuses AS T1 JOIN degrees AS T2 ON T1.id = T2.campus WHERE T2.year >= 1998 AND T2.year <= 2002 GROUP BY T1.campus
SELECT "T1"."campus", SUM("T2"."degrees") FROM "campuses" "T1" JOIN "degrees" "T2" ON "T1"."id" = "T2"."campus" AND "T2"."year" <= 2002 AND "T2"."year" >= 1998 GROUP BY "T1"."campus"