Database: cre_Doc_Tracking_DB
Question: Which employees have either destroyed a document or made an authorization to do so? Return their employee ids.
SQL:
SELECT Destroyed_by_Employee_ID FROM Documents_to_be_destroyed UNION SELECT Destruction_Authorised_by_Employee_ID FROM Documents_to_be_destroyed