What is the total number of degrees that are conferred in "California State University-Channel Islands"?
select sum(degrees) from campuses as t1 join degrees as t2 on t1.id = t2.campus where t1.campus = "California state university-channel Islands"
How about "San Jose State University" over all years?
select sum(degrees) from campuses as t1 join degrees as t2 on t1.id = t2.campus where t1.campus = "San jose state University"
How about in year 2001?
select degrees from campuses as t1 join degrees as t2 on t1.id = t2.campus where t1.campus = "San jose state University" and t2.year = 2001
How about in year 2000?
select degrees from campuses as t1 join degrees as t2 on t1.id = t2.campus where t1.campus = "San jose state University" and t2.year = 2000