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

What is the number of faculty lines in campus 'Long Beach State University' in 2002?
SELECT faculty FROM faculty AS T1 JOIN campuses AS T2 ON T1.campus = T2.id WHERE T1.year = 2002 AND T2.campus = "Long Beach State University"
SELECT "faculty" FROM "faculty" AS "T1" JOIN "campuses" AS "T2" ON "Long Beach State University" = "T2"."campus" AND "T1"."campus" = "T2"."id" WHERE "T1"."year" = 2002