Due to lower salary of salespersons may yield skewed total salary in the previous reports. The HR manager wants to calculate total salaries and count of only non-salespersons of each department and job id. Include total of salary and the number of employees of the groups, department id, job id in your report. Also, total sum of each department and total number of each department should be in included in the result (HINT: You need to use ROLLUP in GROUP BY clause). (Oracle SQL Developer)

HE ACCOUNTS + BONUSES + COUNTRIES # DBUSER 6-0 DEPARTMENTS DEPARTMENT_ID 1 DEPARTMENT_NAME - MANAGER_ID SU LOCATION_ID EMPLOYEES EMPLOYEE_ID - FIRST_NAME .. LAST_NAME EMAIL IPHONE_NUMBER HIRE DATE JOB_ID 0 SALARY H I COMMISSION_PCT HUMANAGER_ID S DEPARTMENT_ID 0 JOB_HISTORY 6- JOBS JOB ID JOB_TITLE MIN_SALARY MAX_SALARY # LOCATIONS 0 ORDERS REGIONS HE ACCOUNTS + BONUSES + COUNTRIES # DBUSER 6-0 DEPARTMENTS DEPARTMENT_ID 1 DEPARTMENT_NAME - MANAGER_ID SU LOCATION_ID EMPLOYEES EMPLOYEE_ID - FIRST_NAME .. LAST_NAME EMAIL IPHONE_NUMBER HIRE DATE JOB_ID 0 SALARY H I COMMISSION_PCT HUMANAGER_ID S DEPARTMENT_ID 0 JOB_HISTORY 6- JOBS JOB ID JOB_TITLE MIN_SALARY MAX_SALARY # LOCATIONS 0 ORDERS REGIONS