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

What is the campus fee in the year 2000 for San Jose State University?
SELECT t1.campusfee FROM csu_fees AS t1 JOIN campuses AS t2 ON t1.campus = t2.id WHERE t2.campus = "San Jose State University" AND t1.year = 2000
SELECT "t1"."campusfee" FROM "csu_fees" AS "t1" JOIN "campuses" AS "t2" ON "San Jose State University" = "t2"."campus" AND "t1"."campus" = "t2"."id" WHERE "t1"."year" = 2000