I was wondering what the maximum number of circulation history documents is for a single employee?
select count ( * ) from employees join circulation_history on circulation_history.employee_id = employees.employee_id group by employees.employee_id order by count ( * ) desc limit 1
Which employee are those documents associated with?
select employees.employee_name from employees join circulation_history on circulation_history.employee_id = employees.employee_id group by employees.employee_id order by count ( * ) desc limit 1
Ok, and how many drafts are associated with Kenyon?
select count ( * ) from employees join circulation_history on circulation_history.employee_id = employees.employee_id where employee_name = "Kenyon"