Task: Text to Code
Input (English): SQL: SELECT Count ( * ) FROM faculty WHERE Campus = 2004 AND Year = "San Francisco State University"
Feedback: Supersede faculty with discipline enrollments , campus with year and year with corresponding campus .
Output (English): SELECT sum(t1.graduate) FROM discipline_enrollments AS t1 JOIN campuses AS t2 ON t1.campus  =  t2.id WHERE t1.year  =  2004 AND t2.campus  =  "San Francisco State University"