report the total number of degrees granted between 1998 and 2002.
CREATE TABLE degrees (
    degrees INTEGER,
    campus VARCHAR,
    year VARCHAR
)

CREATE TABLE campuses (
    campus VARCHAR,
    id VARCHAR
)
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
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: report the total number of degrees granted between 1998 and 2002. ### Input: CREATE TABLE degrees (
    degrees INTEGER,
    campus VARCHAR,
    year VARCHAR
)

CREATE TABLE campuses (
    campus VARCHAR,
    id VARCHAR
) ### Response: 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