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
Which universities are in Los Angeles county and opened after 1950?
assistant
SELECT campus FROM campuses WHERE county = 'Los Angeles' AND YEAR > 1950;
human
What about before 1950?
assistant
SELECT campus FROM campuses WHERE county = 'Los Angeles' AND YEAR < 1950;
human
What are the years they opened?
assistant
SELECT year FROM campuses WHERE county = "Los Angeles" AND YEAR < 1950 ;