Task: Text to Code
Input (English): Step 1: For each row in Student table, find the corresponding rows in Lives_in table.
Step 2: find Fname of the results of step 1 with largest value of room_number
Output (English): SELECT T1.Fname FROM Student AS T1 JOIN Lives_in AS T2 ON T1.StuID = T2.stuid ORDER BY T2.room_number Desc LIMIT 1