human
Schema:
Campuses (Id, Campus, Location, County, Year)
csu_fees (Campus, Year, CampusFee)
degrees (Year, Campus, Degrees)
discipline_enrollments (Campus, Discipline, Year, Undergraduate, Graduate)
enrollments (Campus, Year, TotalEnrollment_AY, FTE_AY)
faculty (Campus, Year, Faculty)
Please answer with SQL.
assistant
Sure, I understand.
human
Hello. What universities are in San Francisco? | Would you like to know the names of all campuses located in San Francisco? | That would be great!
assistant
SELECT Campus FROM Campuses WHERE Location = 'San Francisco';
human
Okay. What was the fee of San Francisco State University in 1996?
assistant
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;
human
And which campus had a fee of 2258 in 1996?
assistant
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 ;