CREATE TABLE csu_fees (campus NUMBER, year NUMBER, campusfee NUMBER)
CREATE TABLE discipline_enrollments (campus NUMBER, discipline NUMBER, year NUMBER, undergraduate NUMBER, graduate NUMBER)
CREATE TABLE enrollments (campus NUMBER, year NUMBER, totalenrollment_ay NUMBER, fte_ay NUMBER)
CREATE TABLE faculty (campus NUMBER, year NUMBER, faculty NUMBER)
CREATE TABLE degrees (year NUMBER, campus NUMBER, degrees NUMBER)
CREATE TABLE campuses (id NUMBER, campus CLOB, location CLOB, county CLOB, year NUMBER)

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" "t1" JOIN "faculty" "t2" ON "t1"."id" = "t2"."campus" AND "t2"."faculty" <= 1000 AND "t2"."faculty" >= 600 WHERE "T1"."year" = 2004