Advertisement
Alhiris

Untitled

Mar 28th, 2020
314
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.48 KB | None | 0 0
  1. SELECT
  2.     D.DEPARTMENT_ID,
  3.     D.DEPARTMENT_NAME,
  4.     MIN(E.SALARY) MINIM
  5. FROM
  6.     EMPLOYEES     E,
  7.     DEPARTMENTS   D
  8. WHERE
  9.     E.DEPARTMENT_ID = D.DEPARTMENT_ID
  10. GROUP BY
  11.     D.DEPARTMENT_ID,
  12.     D.DEPARTMENT_NAME
  13. HAVING
  14.     AVG(SALARY) = (
  15.         SELECT
  16.             MAX(AVG(E.SALARY))
  17.         FROM
  18.             EMPLOYEES     E,
  19.             DEPARTMENTS   D
  20.         WHERE
  21.             E.DEPARTMENT_ID = D.DEPARTMENT_ID
  22.         GROUP BY
  23.             D.DEPARTMENT_ID
  24.     );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement