Task: Text to Code
Input (English): Step 1: For each row in Patient table, find the corresponding rows in Appointment table.
Step 2: find Name of the results of step 1 whose ExaminationRoom equals 111
Output (English): SELECT T1.Name FROM Patient AS T1 JOIN Appointment AS T2 ON T1.SSN = T2.Patient WHERE T2.ExaminationRoom = 111