CREATE TABLE campuses (id VARCHAR(255), campus VARCHAR(255)); CREATE TABLE csu_fees (campusfee VARCHAR(255), campus VARCHAR(255), year VARCHAR(255))
Find the campus fee of "San Jose State University" in year 2000.
    
SQL: 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