Find the campus fee of "San Jose State University" in year 2000.
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
What is the campus id of San Jose State University?
select id from campuses where campus = "San jose state University"
What is the campus fee of that?
select t1.campusfee from csu_fees as t1 join campuses as t2 on t1.campus = t2.id where t2.campus = "San jose state University"
What year is that for?
select t1.year from csu_fees as t1 join campuses as t2 on t1.campus = t2.id where t2.campus = "San jose state University"
What county is San Jose State University in?
select county from campuses where campus = "San jose state University"
What is the location of that university?
select location from campuses where campus = "San jose state University"