SELECT AVG(campusfee) FROM csu_fees WHERE year = 1996
Find the average fee on a CSU campus in 1996
CREATE TABLE discipline_enrollments (
    campus number,
    discipline number,
    year number,
    undergraduate number,
    graduate number
)

CREATE TABLE faculty (
    campus number,
    year number,
    faculty number
)

CREATE TABLE enrollments (
    campus number,
    year number,
    totalenrollment_ay number,
    fte_ay number
)

CREATE TABLE campuses (
    id number,
    campus text,
    location text,
    county text,
    year number
)

CREATE TABLE degrees (
    year number,
    campus number,
    degrees number
)

CREATE TABLE csu_fees (
    campus number,
    year number,
    campusfee number
)