select  d.DEPT_NAME,
j.JOB_TITLE,
e.EMP_FIRSTNAME + ' , ' + e.EMP_LASTNAME Employee_Name,
count(s.EMP_ID)  total_number_salaries,
sum(s.SALARY_VALUE) total_amount_salaries,
from
salary s ,
EMPLOYEE e ,
DEPARTMENT d ,
JOB j
where e.EMP_ID = s.EMP_ID
and e.DEPT_ID = d.DEPT_ID
and j.JOB_ID = e.JOB_ID