SELECT sum(faculty) FROM faculty WHERE YEAR  =  2002
How many faculty, in total, are there in the year 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) 
);
INSERT INTO Campuses VALUES [(1, 'California State University-Bakersfield', 'Bakersfield', 'Kern', 1965), (2, 'California State University-Channel Islands', 'Camarillo', 'Ventura', 2002)]
INSERT INTO csu_fees VALUES [(1, 1996, 1951), (2, 2003, 1868)]
INSERT INTO degrees VALUES [(1990, 1, 701), (1991, 1, 681)]
INSERT INTO discipline_enrollments VALUES [(1, 4, 2004, 248, 0), (1, 5, 2004, 811, 73)]
INSERT INTO enrollments VALUES [(1, 1956, 384, 123), (1, 1957, 432, 151)]
INSERT INTO faculty VALUES [(1, 2002, 357.1), (2, 2002, 48.4)]