Show the id of each employee and the number of document destruction authorised by that employee.
CREATE TABLE Documents_to_be_destroyed (
    Destruction_Authorised_by_Employee_ID VARCHAR
)
SELECT Destruction_Authorised_by_Employee_ID, COUNT(*) FROM Documents_to_be_destroyed GROUP BY Destruction_Authorised_by_Employee_ID
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Show the id of each employee and the number of document destruction authorised by that employee. ### Input: CREATE TABLE Documents_to_be_destroyed (
    Destruction_Authorised_by_Employee_ID VARCHAR
) ### Response: SELECT Destruction_Authorised_by_Employee_ID, COUNT(*) FROM Documents_to_be_destroyed GROUP BY Destruction_Authorised_by_Employee_ID