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

What is the campus fee of 'San Francisco State University' in year 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"