ในปี พ.ศ. 2547 "San Francisco State University" มีคณะกี่คณะ?ไม่จำเป็นต้องใช้ตารางทั้งหมด
How many faculty lines are there in "San Francisco State University" in year 2004?It is not neccessary to use all the tables.
 campuses:  (id [ VARCHAR ] campus [ VARCHAR) ]
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"