hi I was wondering how many counties you have information for?
select count ( distinct t1.county ) from campuses as t1 join degrees as t2 on t1.id = t2.campus
how many schools are in Orange county?
select count ( * ) from campuses as t1 join degrees as t2 on t1.id = t2.campus where t1.county = "Orange"
can you tell me how many degrees have been granted for each Orange county campus since the 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