Примеры команд SQL в рамках урока #10

-- Агрегация данных в SQL. Функции SUM, MIN, MAX, AVG
-- https://www.youtube.com/watch?v=tzR4Ar6zG80

-------------------------------------------
-- Примеры команд SQL в рамках урока #10


SELECT SUM(SALARY)
FROM EMPLOYEES;


SELECT JOB_ID, SUM(SALARY)
FROM EMPLOYEES
GROUP BY JOB_ID;


SELECT JOB_ID, SUM(SALARY), MIN(SALARY)
FROM EMPLOYEES
GROUP BY JOB_ID;


SELECT JOB_ID, SUM(SALARY), MIN(SALARY), MAX(SALARY)
FROM EMPLOYEES
GROUP BY JOB_ID;


SELECT JOB_ID, SUM(SALARY), MIN(SALARY), MAX(SALARY), avg(SALARY)
FROM EMPLOYEES
GROUP BY JOB_ID;


SELECT
    JOB_ID AS ДОЛЖНОСТЬ_СОТРУДНИКА,
    SUM(SALARY) AS ОБЩАЯ_ЗП,
    MIN(SALARY) AS МИНИМАЛЬНАЯ_ЗП,
    MAX(SALARY) AS МАКСИМАЛЬНАЯ_ЗП,
    avg(SALARY) AS СРЕДНЯЯ_ЗП
FROM EMPLOYEES
GROUP BY JOB_ID;


SELECT
    JOB_ID AS ДОЛЖНОСТЬ_СОТРУДНИКА,
    DEPARTMENT_ID AS ДЕПАРТАМЕНТ_СОТРУДНИКА,
    SUM(SALARY) AS ОБЩАЯ_ЗП,
    MIN(SALARY) AS МИНИМАЛЬНАЯ_ЗП,
    MAX(SALARY) AS МАКСИМАЛЬНАЯ_ЗП,
    avg(SALARY) AS СРЕДНЯЯ_ЗП
FROM EMPLOYEES
WHERE DEPARTMENT_ID IN (90, 100)
GROUP BY JOB_ID, DEPARTMENT_ID
ORDER BY JOB_ID, DEPARTMENT_ID;