Task: Text to Code
Input (English): SQL: SELECT Count ( * ) FROM faculty WHERE Year = "San Francisco State University" AND Year = 2004
Feedback: You need to make sure that the campus is of San Francisco State University only.
Output (English): SELECT faculty FROM faculty AS T1 JOIN campuses AS T2 ON T1.campus  =  T2.id WHERE T1.year  =  2004 AND T2.campus  =  "San Francisco State University"