Task: Text to Code
Input (English): Step 1: For each row in Documents_to_be_Destroyed table, find corresponding rows in All_Documents table and in Employees table.
Step 2: find Employee_Name, Document_Name of the results of step 1
Output (English): SELECT T2.Employee_Name , T1.Document_Name FROM All_Documents AS T1 JOIN Employees AS T2 JOIN Documents_to_be_Destroyed AS T3 ON T1.Document_ID = T3.Document_ID AND T3.Destroyed_by_Employee_ID = T2.Employee_ID