Database: csu_1
Question: List the campus that have between 600 and 1000 faculty lines in year 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