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
Find the campus fee of 'San Jose State University' in year 2000.
assistant
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;
human
What is the campus id of San Jose State University?
assistant
SELECT id FROM campuses WHERE campus = 'San Jose State University';
human
What is the campus fee of that?
assistant
SELECT t1.campusfee FROM csu_fees AS t1 JOIN campuses AS t2 ON t1.campus = t2.id WHERE t2.campus = 'San Jose State University';
human
What year is that for?
assistant
SELECT t1.Year FROM csu_fees AS t1 JOIN campuses AS t2 ON t1.campus = t2.id WHERE t2.campus = 'San Jose State University';
human
What county is San Jose State University in?
assistant
SELECT County FROM campuses WHERE campus = 'San Jose State University';
human
What is the location of that university?
assistant
SELECT Location FROM campuses WHERE campus = "San Jose State University" ;