Task: Text to Code
Input (English): Step 1: For each row in Campuses table, find corresponding rows in discipline_enrollments table and in faculty table.
Step 2: find Faculty of the results of step 1 whose Undergraduate greater than 1956 and discipline_enrollments's Year equals 400
Output (English): SELECT T3.Faculty FROM Campuses AS T1 JOIN discipline_enrollments AS T2 ON T2.Campus = T1.Id JOIN faculty AS T3 ON T1.Id = T3.Campus WHERE T2.Undergraduate > 1956 AND T2.Year = 400