dokuwiki

select job_id, department_name, e.manager_id, count(e.employee_id)
  from employees e, departments d
where e.department_id = d.department_id
  group by 
  grouping sets
 -- (department_name, job_id, e.manager_id),
( (department_name, job_id),
  (job_id, e.manager_id) )