What are the campuses that had between 600 and 1000 faculty members in 2004?
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 t1.year = 2004