SELECT COUNT(EMPLOYEE_ID) AS "TOTAL Employee",
MAX(SALARY) AS "MAX SAL",
MIN(SALARY) AS "MIN SAL",
AVG(SALARY) AS "AVG SAL",
SUM(SALARY) AS "Total SAL"
FROM employees
GROUP BY DEPARTMENT_ID;
SELECT COUNT(EMPLOYEE_ID) AS "TOTAL Employee",
MAX(SALARY) AS "MAX SAL",
MIN(SALARY) AS "MIN SAL",
AVG(SALARY) AS "AVG SAL",
SUM(SALARY) AS "Total SAL"
FROM employees
GROUP BY DEPARTMENT_ID;
Add your comment