How many universities are in Los Angeles?
select count(campus) from campuses where county = "Los Angeles"
How many of them opened after 1950?
select count(*) from campuses where county = "Los Angeles" and year > 1950
Please show their names.
select campus from campuses where county = "Los Angeles" and year > 1950