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

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