That would be great!
select campus from campuses where location = 'San Francisco'
Okay. What was the fee of San Francisco State University in 1996?
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
And which campus had a fee of 2258 in 1996?
select t1.campus from campuses as t1 join csu_fees as t2 on t1.id = t2.campus where t2.year = 1996 and t2.campusfee = 2258
Interesting! What county is that in?
select t1.county from campuses as t1 join csu_fees as t2 on t1.id = t2.campus where t2.year = 1996 and t2.campusfee = 2258
And what county is San Francisco State University in?
select county from campuses where campus = 'San francisco state University'