SELECT dept_name, [sum male salary], [sum female salary]
FROM Department D
LEFT JOIN
(
SELECT SUM(Salaries) AS [sum male salary],dept_id FROM Staff
GROUP BY dept_id, gender
HAVING gender = 'M'
) M ON D.dept_id = M.dept_id
LEFT JOIN
(
SELECT SUM(Salaries) AS [sum female salary],dept_id FROM Staff
GROUP BY dept_id, gender
HAVING gender = 'F'
) F ON D.dept_id = F.dept_id