Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- D.DEPARTMENT_ID,
- D.DEPARTMENT_NAME,
- MIN(E.SALARY) MINIM
- FROM
- EMPLOYEES E,
- DEPARTMENTS D
- WHERE
- E.DEPARTMENT_ID = D.DEPARTMENT_ID
- GROUP BY
- D.DEPARTMENT_ID,
- D.DEPARTMENT_NAME
- HAVING
- AVG(SALARY) = (
- SELECT
- MAX(AVG(E.SALARY))
- FROM
- EMPLOYEES E,
- DEPARTMENTS D
- WHERE
- E.DEPARTMENT_ID = D.DEPARTMENT_ID
- GROUP BY
- D.DEPARTMENT_ID
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement