How many faculty lines are there in 'San Francisco State University' in year 2004?
CREATE TABLE campuses (
    id VARCHAR,
    campus VARCHAR
)

CREATE TABLE faculty (
    campus VARCHAR,
    year VARCHAR
)
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 campuses (
    id VARCHAR,
    campus VARCHAR
)

CREATE TABLE faculty (
    campus VARCHAR,
    year VARCHAR
) ### 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"