Database: cre_Doc_Control_Systems
Question: Which employee has showed up in most circulation history documents. List the employee's name and the number of drafts and copies.
SQL:
SELECT Employees.employee_name , count(*) FROM Employees JOIN Circulation_History ON Circulation_History.employee_id = Employees.employee_id GROUP BY Circulation_History.document_id , Circulation_History.draft_number , Circulation_History.copy_number ORDER BY count(*) DESC LIMIT 1;