Which year did any college confer the most amount of degrees?
select t3.year from campuses as t1 join faculty as t2 on t1.id = t2.campus join degrees as t3 on t1.id = t3.campus and t2.year = t3.year order by t3.degrees desc limit 1
Yes
select t1.campus from campuses as t1 join faculty as t2 on t1.id = t2.campus join degrees as t3 on t1.id = t3.campus and t2.year = t3.year where t3.year = 2003 order by t3.degrees desc limit 1
How many faculty were at California State University-Channel Islands, in the year of 2002?
select t2.faculty from campuses as t1 join faculty as t2 on t1.id = t2.campus join degrees as t3 on t1.id = t3.campus and t2.year = t3.year where t2.year = 2002 and t1.campus = "California state university-channel Islands"
Yes
select t2.faculty from campuses as t1 join faculty as t2 on t1.id = t2.campus join degrees as t3 on t1.id = t3.campus and t2.year = t3.year where t2.year = 2002 and t1.campus = "California state university-Chico"
How about for the year 1965?
select distinct t1.location from campuses as t1 join faculty as t2 on t1.id = t2.campus join degrees as t3 on t1.id = t3.campus and t2.year = t3.year where t1.year = 1965 and t1.campus = "California state university-Bakersfield"