How many campuses are in Orange county?
select count(*) from campuses where county = "Orange"
How many degrees have these campuses granted over all years?
select t1.campus, sum(t2.degrees) from campuses as t1 join degrees as t2 on t1.id = t2.campus where t1.county = "Orange" group by t1.campus
How about the number after year 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