-- SELECT DEPARTMENT_ID AS DEPT_ID, COUNT(DISTINCT JOB_ID) AS UNIQUE_JOB_ID FROM HR.EMPLOYEES GROUP BY DEPARTMENT_ID -- SELECT DEPARTMENT_ID,SUM(SALARY) FROM HR.EMPLOYEES GROUP BY DEPARTMENT_ID; -- ...