What is the location of "San Francisco State University"?
select location from campuses where campus = "San francisco state University"
What are its campus fees over all years?
select t1.campusfee from csu_fees as t1 join campuses as t2 on t1.campus = t2.id where t2.campus = "San francisco state University"
How about in year 2000?
select t1.campusfee from csu_fees as t1 join campuses as t2 on t1.campus = t2.id where t2.campus = "San francisco state University" and t1.year = 2000