select * ,(
    select count(salary)
    from dept_emp d2
    left join salaries s on d2.emp_no = s.emp_no
    where d1.dept_no = d2.dept_no
) sum
from departments d1