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