CREATE TABLE discipline_enrollments (undergraduate INT, campus VARCHAR, year VARCHAR)
CREATE TABLE campuses (id VARCHAR, campus VARCHAR)

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