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