Task: Text to Code
Input (English): Step 1: For each row in Campuses table, find the corresponding rows in faculty table.
Step 2: find rows of the results of step 1 whose County equals Los Angeles and faculty's Year greater than 1950 and faculty's Year greater than 2002
Output (English): SELECT * FROM Campuses AS T1 JOIN faculty AS T2 ON T1.Id = T2.Campus WHERE T1.County = "Los Angeles" AND T2.Year > 2002 AND T2.Year > 1950