Guest User

Untitled

a guest
Oct 19th, 2018
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.18 KB | None | 0 0
  1. SELECT ID, NAME, CHIEF_ID, SALARY, DEPARTMENT_ID
  2. FROM EMPLOYEE A
  3. WHERE SALARY/2 = (SELECT AVG(SALARY)
  4. FROM EMPLOYEE B
  5. WHERE A.DEPARTMENT_ID = B.DEPARTMENT_ID AND A.CHIEF_ID = A.ID)
Add Comment
Please, Sign In to add comment