CREATE TABLE campuses (id DECIMAL, campus TEXT, location TEXT, county TEXT, year DECIMAL)
CREATE TABLE degrees (year DECIMAL, campus DECIMAL, degrees DECIMAL)
CREATE TABLE csu_fees (campus DECIMAL, year DECIMAL, campusfee 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 discipline_enrollments (campus DECIMAL, discipline DECIMAL, year DECIMAL, undergraduate DECIMAL, graduate DECIMAL)

What is the campus fee for San Francisco State University in 1996?
SELECT campusfee FROM campuses AS T1 JOIN csu_fees AS T2 ON T1.id = t2.campus WHERE t1.campus = "San Francisco State University" AND T2.year = 1996
SELECT "campusfee" FROM "campuses" AS "T1" JOIN "csu_fees" AS "T2" ON "T1"."id" = "t2"."campus" AND "T2"."year" = 1996 WHERE "San Francisco State University" = "t1"."campus"