Show the id of each employee who has authorized document destruction.
select destruction_authorised_by_employee_id from documents_to_be_destroyed
For each of them, count the number of destroyed documents they authorized.
select destruction_authorised_by_employee_id, count(*) from documents_to_be_destroyed group by destruction_authorised_by_employee_id