CREATE TABLE campuses (id NUMBER, campus CLOB, location CLOB, county CLOB, year NUMBER)
CREATE TABLE enrollments (campus NUMBER, year NUMBER, totalenrollment_ay NUMBER, fte_ay NUMBER)
CREATE TABLE faculty (campus NUMBER, year NUMBER, faculty NUMBER)
CREATE TABLE discipline_enrollments (campus NUMBER, discipline NUMBER, year NUMBER, undergraduate NUMBER, graduate NUMBER)
CREATE TABLE csu_fees (campus NUMBER, year NUMBER, campusfee NUMBER)
CREATE TABLE degrees (year NUMBER, campus NUMBER, degrees NUMBER)

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