Database: csu_1
Question: What are the campuses that had between 600 and 1000 faculty members in 2004?
SQL:
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