SELECT job_id, SUM(CASE WHEN department_id = '20' THEN salary ELSE NULL END) AS "20", SUM(CASE WHEN department_id = '50' THEN salary ELSE NULL END) AS "50", SUM(CASE WHEN department_id = '80' THEN salary ELSE NULL END) AS "80", SUM(CASE WHEN department_id = '90' THEN salary ELSE NULL END) AS "90", SUM(salary)
FROM employees
GROUP BY Job_id;