Show the campus fee of all campuses in year 1996.
select campusfee from campuses as t1 join csu_fees as t2 on t1.id = t2.campus where t2.year = 1996
What is the highest among them?
select max(campusfee) from campuses as t1 join csu_fees as t2 on t1.id = t2.campus where t2.year = 1996
What is the fee of "San Francisco State University"?
select campusfee from campuses as t1 join csu_fees as t2 on t1.id = t2.campus where t1.campus = "San francisco state University" and t2.year = 1996