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
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
select t1 . campus from campuses as t1 join faculty as t2 on t1 . id = t2 . campus where t2 . faculty > = value and t2 . faculty < = value and t1 . year = value
What are the campuses that had between 600 and 1000 faculty members in 2004 ?