Task: Text to Code
Input (English): find the number of rows in faculty table whose Year equals 1
Output (English): SELECT Count ( * ) FROM faculty WHERE Year = 1