Task: Text to Code
Input (English): find the number of rows in faculty table whose Year equals 2002 and Year equals Long Beach State University
Output (English): SELECT Count ( * ) FROM faculty WHERE Year = "Long Beach State University" AND Year = 2002