Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE campuses ( id number, campus text, location text, county text, year number )
TABLE: CREATE TABLE faculty ( campus number, year number, faculty number )
TABLE: CREATE TABLE discipline_enrollments ( campus number, discipline number, year number, undergraduate number, graduate number )
TABLE: CREATE TABLE degrees ( year number, campus number, degrees number )
TABLE: CREATE TABLE enrollments ( campus number, year number, totalenrollment_ay number, fte_ay number )
TABLE: CREATE TABLE csu_fees ( campus number, year number, campusfee number )

### Question ###
What is the campus fee of 'San Francisco State University' in year 1996?

### Accurate SQL ###

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