How many campuses have faculty lines?
select count(distinct t1.campus) from campuses as t1 join faculty as t2 on t1.id = t2.campus
Show their faculty lines in year 2004.
select t2.faculty from campuses as t1 join faculty as t2 on t1.id = t2.campus where t2.year = 2004
How many of them are between 600 and 1000?
select count(*) from campuses as t1 join faculty as t2 on t1.id = t2.campus where t2.faculty >= 600 and t2.faculty <= 1000 and t2.year = 2004
Show the names of these campuses.
select t1.campus from campuses as t1 join faculty as t2 on t1.id = t2.campus where t2.faculty >= 600 and t2.faculty <= 1000 and t2.year = 2004