Task: Text to Code
Input (English): find each value of Destruction_Authorised_by_Employee_ID in Documents_to_be_Destroyed table along with the number of Document_ID of the corresponding rows to each value
Output (English): SELECT Destruction_Authorised_by_Employee_ID , Count ( DISTINCT Document_ID ) FROM Documents_to_be_Destroyed GROUP BY Destruction_Authorised_by_Employee_ID