How many degrees did "San Jose State University" confer in 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
What about for campus id 5?
select sum ( degrees ) from degrees where campus = 5
What is the name of that campus?
select distinct t1.campus from campuses as t1 join degrees as t2 on t1.id = t2.campus where t2.campus = 5
What is the name of campus with id 19?
select distinct t1.campus from campuses as t1 join degrees as t2 on t1.id = t2.campus where t2.campus = 19
How many degrees did "San Jose State University" confer in 2001?
select sum ( 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