What are the id of each employee and the number of document destruction authorised by that employee?
select destruction_authorised_by_employee_id, count(*) from documents_to_be_destroyed group by destruction_authorised_by_employee_id