Database: cre_Doc_Tracking_DB
Question: List the names of the employees who authorized the destruction of documents and the employees who destroyed the corresponding documents.
SQL:
SELECT T2.employee_name ,  T3.employee_name FROM Documents_to_be_destroyed AS T1 JOIN Employees AS T2 ON T1.Destruction_Authorised_by_Employee_ID = T2.employee_id JOIN Employees AS T3 ON T1.Destroyed_by_Employee_ID = T3.employee_id;