examine the following statement: select department id, manager id, job id, sum(salary) from employees group by rollup(department id, manager id) what extra data will this query generate?
Mark for Review
Sum of salaries for (department_id, job_id) and (department_id, manager_id) (*)
Sum of salaries for (department_id, job_id, manager_id)
Subtotals for (job_id, manager_id)
The statement will fail.