CREATE TABLE degrees (Id VARCHAR2)
CREATE TABLE campuses (Id VARCHAR2)

How many degrees were conferred in 'San Jose State University' 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
SELECT "degrees" FROM "campuses" "T1" JOIN "degrees" "T2" ON "t1"."Id" = "t2"."campus" WHERE "San Jose State University" = "t1"."campus" AND "t2"."year" = 2000