Translate the following question to SQL: how many degrees were conferred between 1998 and 2002?

Schema: CREATE TABLE Campuses (
    Id INTEGER   PRIMARY KEY,
    Campus TEXT,
    Location TEXT,
    County TEXT,
    Year INTEGER
);

CREATE TABLE csu_fees (
    Campus INTEGER   PRIMARY KEY,
    Year INTEGER,
    CampusFee INTEGER,
    FOREIGN KEY (Campus) REFERENCES Campuses(Id)
);

CREATE TABLE degrees (
    Year INTEGER   PRIMARY KEY,
    Campus INTEGER   PRIMARY KEY,
    Degrees INTEGER,
    PRIMARY KEY (Year, Campus),
    UNIQUE (Year, Campus),
    FOREIGN KEY (Campus) REFERENCES Campuses(Id)
);

CREATE TABLE discipline_enrollments (
    Campus INTEGER   PRIMARY KEY,
    Discipline INTEGER   PRIMARY KEY,
    Year INTEGER,
    Undergraduate INTEGER,
    Graduate INTEGER,
    PRIMARY KEY (Campus, Discipline),
    UNIQUE (Campus, Discipline),
    FOREIGN KEY (Campus) REFERENCES Campuses(Id)
);

CREATE TABLE enrollments (
    Campus INTEGER   PRIMARY KEY,
    Year INTEGER   PRIMARY KEY,
    TotalEnrollment_AY INTEGER,
    FTE_AY INTEGER,
    PRIMARY KEY (Campus, Year),
    UNIQUE (Campus, Year),
    FOREIGN KEY (Campus) REFERENCES Campuses(Id)
);

CREATE TABLE faculty (
    Campus INTEGER,
    Year INTEGER,
    Faculty REAL,
    FOREIGN KEY (Campus) REFERENCES Campuses(Id)
);
user
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
assistant