Task: Text to Code
Input (English): SQL: 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
Feedback: Ensure that you search for faculty's faculty rather than rows count of faculty table.
Output (English): SELECT faculty FROM faculty AS T1 JOIN campuses AS T2 ON T1.campus  =  T2.id WHERE T1.year  =  2002 AND T2.campus  =  "Long Beach State University"