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

How many undergraduates are there in 'San Jose State University' in year 2004?
SELECT SUM(t1.undergraduate) FROM discipline_enrollments AS t1 JOIN campuses AS t2 ON t1.campus = t2.id WHERE t1.year = 2004 AND t2.campus = "San Jose State University"
SELECT SUM("t1"."undergraduate") FROM "discipline_enrollments" AS "t1" JOIN "campuses" AS "t2" ON "San Jose State University" = "t2"."campus" AND "t1"."campus" = "t2"."id" WHERE "t1"."year" = 2004