Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT EMPLOYEE.NAME, EMPLOYEE.POSITION FROM EMPLOYEE WHERE EMPLOYEE.DEPARTMENT_ID = @id;
- SELECT EMPLOYEE.NAME, EMPLOYEE.ID AS ID_CH FROM EMPLOYEE WHERE (
- EMPLOYEE.SALARY > (2 * (SELECT AVG(EMPLOYEE.SALARY) FROM EMPLOYEE WHERE EMPLOYEE.CHIEF_ID = ID_CH)) AND
- 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