Advertisement
Guest User

Untitled

a guest
Oct 16th, 2019
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.24 KB | None | 0 0
  1. SELECT t1.[NAME] as CHIEF_NAME
  2. FROM EMPLOYEE As t1 JOIN (
  3. SELECT CHIEF_ID, AVG(SALARY) AS AVG_EMPLOYEE_SALARY
  4. FROM EMPLOYEE
  5. WHERE CHIEF_ID IS NOT NULL
  6. GROUP BY CHIEF_ID) AS t2 ON t1.ID = t2.CHIEF_ID
  7. WHERE t1.SALARY > (t2.AVG_EMPLOYEE_SALARY * 2)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement