CREATE TABLE discipline_enrollments (graduate NUMBER, campus VARCHAR2, year VARCHAR2)
CREATE TABLE campuses (id VARCHAR2, campus VARCHAR2)

What is the number of graduates in 'San Francisco State University' in year 2004?
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"
SELECT SUM("t1"."graduate") FROM "discipline_enrollments" "t1" JOIN "campuses" "t2" ON "San Francisco State University" = "t2"."campus" AND "t1"."campus" = "t2"."id" WHERE "t1"."year" = 2004