This is an old revision of the document!
SELECT nvl(departments.department_name, 'Summe Department') as dep, grouping(department_name) as gd, nvl(job_id, 'Summe Jobs') as job, grouping(job_id) as gj, count(last_name), sum(employees.salary) FROM departments, employees WHERE ((departments.department_id = employees.department_id)) group by rollup (department_name, job_id) order by department_name, job_id