Create the following statistical report for the HR departmen

Create the following statistical report for the HR department. Include the department name, the job title and the total salary for every job within a department for those departments whose department ID is greater than 80. Order by the department name and job ID.

this is what i have so far but it is wrong

select department_id, job_id, SUM(A.salary)
FROM EMPLOYEES
where DEPARTMENT_ID > 80
having sum(salary) > 15000
GROUP BY manager_id, job_id, A.salary;

Solution

Answer

select department_ID, department_name, job_ID, job_title, salary, ((SUM(salary) group by job_title) group by department_name where department_id > 80)
from EMPLOYEES
order by department_name, job_ID