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) )