Task: Text to Code
Input (English): Step 1: For each row in Campuses table, find the corresponding rows in faculty table.
Step 2: find the number of rows in the results of step 1 whose Campuses's Campus equals Long Beach State University and faculty's Year equals 2002
Output (English): SELECT Count ( * ) FROM Campuses AS T1 JOIN faculty AS T2 ON T1.Id = T2.Campus WHERE T1.Campus = "Long Beach State University" AND T2.Year = 2002