May I have the ids of those employees who cant authorize the destruction of documents?
SELECT employee_id FROM Employees EXCEPT SELECT Destruction_Authorised_by_Employee_ID FROM Documents_to_be_destroyed
ids of employees who can't authorize the destruction of documents refers to finding employee_id from Employees table that do not appear in Destruction_Authorised_by_Employee_ID from Documents_to_be_destroyed table;