How many campuses are there in Orange county?
select count(*) from campuses where county = "Orange"
How many faculties are there in each campus in 2002?
select t1.campus, t2.faculty from campuses as t1 join faculty as t2 on t1.id = t2.campus where t2.year = 2002
What campus has the largest faculty in Orange county in year 2002?
select max(faculty) from campuses as t1 join faculty as t2 on t1.id = t2.campus where t2.year = 2002 and t1.county = "Orange"
Which campus has more faculties than this number?
select t1.campus from campuses as t1 join faculty as t2 on t1.id = t2.campus where t2.year = 2002 and faculty > (select max(faculty) from campuses as t1 join faculty as t2 on t1.id = t2.campus where t2.year = 2002 and t1.county = "Orange")