Please tell me the number of undergraduates from each campus in the year 2004
select t2.campus, sum ( t1.graduate ) from discipline_enrollments as t1 join campuses as t2 on t1.campus = t2.id where t1.year = 2004 group by t2.campus
please show the undergrads total from each campus
select t2.campus, sum ( t1.undergraduate ) from discipline_enrollments as t1 join campuses as t2 on t1.campus = t2.id group by t2.campus
now please show just the total of graduates from San Francisco State University in 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"