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
report the total number of degrees granted between 1998 and 2002.
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,
	"Campus" INTEGER, 
	"Degrees" INTEGER,
	PRIMARY KEY (Year, Campus),
	FOREIGN KEY (Campus) REFERENCES Campuses(Id)
);



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



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

CREATE TABLE "faculty" ( 
	"Campus" INTEGER, 
	"Year" INTEGER, 
	"Faculty" REAL,
	FOREIGN KEY (Campus) REFERENCES Campuses(Id) 
);



('California  Maritime Academy', 405)
('California Polytechnic State University-San Luis Obispo', 16402)
('California State Polytechnic University-Pomona', 13493)
('California State University-Bakersfield', 4967)
('California State University-Channel Islands', 2)
('California State University-Chico', 13762)
('California State University-Dominguez Hills', 8681)
('California State University-East Bay', 11622)
('California State University-Fullerton', 23457)
('California State University-Los Angeles', 13032)
('California State University-Monterey Bay', 1626)
('California State University-Northridge', 22141)
('California State University-Sacramento', 20155)
('California State University-San Bernardino', 10959)
('California State University-San Marcos', 5275)
('California State University-Stanislaus', 6181)
('Fresno State University', 14060)
('Humboldt State University', 6963)
('Long Beach State University', 22502)
('San Diego State University', 26418)
('San Francisco State University', 21323)
('San Jose State University', 19945)
('Sonoma State University', 7204)
