department wise salary

SELECT departments.DEPARTMENT_NAME, employees.DEPARTMENT_ID,
employees.JOB_ID,SUM(SALARY)
FROM employees JOIN departments ON employees.DEPARTMENT_ID = departments.DEPARTMENT_ID
GROUP BY employees.DEPARTMENT_ID