Task: Text to Code
Input (English): Step 1: For each row in Addresses table, find the corresponding rows in Student_Addresses table.
Step 2: find the average monthly_rental of each value of student_id in the results of step 1.
Step 3: find student_id, city of step 1 results with largest value in the results of step 2
Output (English): SELECT T2.student_id , T1.city FROM Addresses AS T1 JOIN Student_Addresses AS T2 ON T1.address_id = T2.address_id GROUP BY T2.student_id ORDER BY Avg ( T2.monthly_rental ) Desc LIMIT 1