Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --Выбрать сотрудников, которые получают зарплату,
- --составляющую болле 3/2 от средней зарплаты для своей должности.
- SELECT first_name, middle_initial, last_name, JOB.[function], salary FROM EMPLOYEE, JOB
- WHERE (EMPLOYEE.job_id = JOB.job_id)
- AND (salary > 1.2 * (SELECT AVG(salary) FROM EMPLOYEE
- GROUP BY job_id
- HAVING JOB.job_id = EMPLOYEE.job_id))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement