Hello. What is the name of the employee that has showed up the most in circulation history documents?
select t1.employee_name from employees as t1 join circulation_history as t2 on t2.employee_id = t1.employee_id group by t1.employee_name order by count ( * ) desc limit 1
How many drafts have they shown up in?
select t1.employee_name, sum ( t2.draft_number ) from employees as t1 join circulation_history as t2 on t2.employee_id = t1.employee_id group by t2.document_id, t2.draft_number, t2.copy_number order by count ( * ) desc limit 1
How many copies have they shown up in?
select sum ( t2.copy_number ) from employees as t1 join circulation_history as t2 on t2.employee_id = t1.employee_id group by t2.document_id, t2.draft_number, t2.copy_number order by count ( * ) desc limit 1