For each Orange county campus, report the number of degrees granted after 2000.
select t1.campus, sum ( t2.degrees ) from campuses as t1 join degrees as t2 on t1.id = t2.campus where t1.county = "Orange" and t2.year > = 2000 group by t1.campus
which year has the highest number of degrees?
select year from degrees order by degrees desc limit 1
which campus has the highest number of degrees?
select t1.campus from campuses as t1 join degrees as t2 on t1.id = t2.campus where t2.degrees = ( select max ( degrees ) from degrees )