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

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" AS "T1" JOIN "degrees" AS "T2" ON "T1"."id" = "T2"."campus" AND "T2"."year" <= 2002 AND "T2"."year" >= 1998 GROUP BY "T1"."campus"