Translate the following question to SQL: List the campus that have between 600 and 1000 faculty lines in year 2004.

Schema: CREATE TABLE Campuses (
    Id INTEGER   PRIMARY KEY,
    Campus TEXT,
    Location TEXT,
    County TEXT,
    Year INTEGER
);

CREATE TABLE csu_fees (
    Campus INTEGER   PRIMARY KEY,
    Year INTEGER,
    CampusFee INTEGER,
    FOREIGN KEY (Campus) REFERENCES Campuses(Id)
);

CREATE TABLE degrees (
    Year INTEGER   PRIMARY KEY,
    Campus INTEGER   PRIMARY KEY,
    Degrees INTEGER,
    PRIMARY KEY (Year, Campus),
    UNIQUE (Year, Campus),
    FOREIGN KEY (Campus) REFERENCES Campuses(Id)
);

CREATE TABLE discipline_enrollments (
    Campus INTEGER   PRIMARY KEY,
    Discipline INTEGER   PRIMARY KEY,
    Year INTEGER,
    Undergraduate INTEGER,
    Graduate INTEGER,
    PRIMARY KEY (Campus, Discipline),
    UNIQUE (Campus, Discipline),
    FOREIGN KEY (Campus) REFERENCES Campuses(Id)
);

CREATE TABLE enrollments (
    Campus INTEGER   PRIMARY KEY,
    Year INTEGER   PRIMARY KEY,
    TotalEnrollment_AY INTEGER,
    FTE_AY INTEGER,
    PRIMARY KEY (Campus, Year),
    UNIQUE (Campus, Year),
    FOREIGN KEY (Campus) REFERENCES Campuses(Id)
);

CREATE TABLE faculty (
    Campus INTEGER,
    Year INTEGER,
    Faculty REAL,
    FOREIGN KEY (Campus) REFERENCES Campuses(Id)
);
user
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
assistant