How many campuses are there that have degrees conferred?
select count(distinct campus) from degrees
How many degrees does each campus confer?
select campus, count(*) from degrees group by campus
Which campus had the most degrees conferred in 1990?
select campus from degrees where year = 2002 group by campus order by sum(degrees) desc limit 1
How about overall?
select campus from degrees group by campus order by sum(degrees) desc limit 1