Task: Text to Code
Input (English): Step 1: For each row in Campuses table, find corresponding rows in enrollments table and in faculty table.
Step 2: find the average FTE_AY in the results of step 1 whose faculty's Year equals 2005 and Faculty equals 357.1
Output (English): SELECT Avg ( T2.FTE_AY ) FROM Campuses AS T1 JOIN enrollments AS T2 ON T2.Campus = T1.Id JOIN faculty AS T3 ON T1.Id = T3.Campus WHERE T3.Year = 2005 AND T3.Faculty = 357.1