How many faculty lines are there in 'San Francisco State University' in year 2004?
CREATE TABLE enrollments (
    campus number,
    year number,
    totalenrollment_ay number,
    fte_ay number
)

CREATE TABLE campuses (
    id number,
    campus text,
    location text,
    county text,
    year number
)

CREATE TABLE faculty (
    campus number,
    year number,
    faculty number
)

CREATE TABLE discipline_enrollments (
    campus number,
    discipline number,
    year number,
    undergraduate number,
    graduate number
)

CREATE TABLE csu_fees (
    campus number,
    year number,
    campusfee number
)

CREATE TABLE degrees (
    year number,
    campus number,
    degrees number
)
SELECT faculty FROM faculty AS T1 JOIN campuses AS T2 ON T1.campus = T2.id WHERE T1.year = 2004 AND T2.campus = "San Francisco State University"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: How many faculty lines are there in 'San Francisco State University' in year 2004? ### Input: CREATE TABLE enrollments (
    campus number,
    year number,
    totalenrollment_ay number,
    fte_ay number
)

CREATE TABLE campuses (
    id number,
    campus text,
    location text,
    county text,
    year number
)

CREATE TABLE faculty (
    campus number,
    year number,
    faculty number
)

CREATE TABLE discipline_enrollments (
    campus number,
    discipline number,
    year number,
    undergraduate number,
    graduate number
)

CREATE TABLE csu_fees (
    campus number,
    year number,
    campusfee number
)

CREATE TABLE degrees (
    year number,
    campus number,
    degrees number
) ### Response: SELECT faculty FROM faculty AS T1 JOIN campuses AS T2 ON T1.campus = T2.id WHERE T1.year = 2004 AND T2.campus = "San Francisco State University"