Advertisement
Guest User

Untitled

a guest
Oct 13th, 2019
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. SELECT DISTINCT EMPLOYEE.NAME, EMPLOYEE.POSITION FROM EMPLOYEE WHERE EMPLOYEE.DEPARTMENT_ID = @id;
  2.  
  3. SELECT EMPLOYEE.NAME, EMPLOYEE.ID AS ID_CH FROM EMPLOYEE WHERE (
  4. EMPLOYEE.SALARY > (2 * (SELECT AVG(EMPLOYEE.SALARY) FROM EMPLOYEE WHERE EMPLOYEE.CHIEF_ID = ID_CH)) AND
  5. EMPLOYEE.ID IN (SELECT DISTINCT EMPLOYEE.ID FROM EMPLOYEE WHERE EMPLOYEE.CHIEF_ID NOT NULL));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement