Task: Text to Code
Input (English): Step 1: For each row in Campuses table, find corresponding rows in csu_fees table and in faculty table.
Step 2: find CampusFee of the results of step 1 whose csu_fees's Year equals 1996 and faculty's Year equals San Jose State University
Output (English): SELECT T2.CampusFee FROM Campuses AS T1 JOIN csu_fees AS T2 ON T2.Campus = T1.Id JOIN faculty AS T3 ON T1.Id = T3.Campus WHERE T2.Year = 1996 AND T3.Year = "San Jose State University"