Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- with depsum as (select sum(salary) sumsal,department_id, department_name
- from employees join departments using(department_id)
- where department_id is not null
- group by department_id),
- avgsumsal as (select avg(sumsal) medie
- from depsum)
- select department_name,sumsal
- from depsum,avgsumsal
- where sumsal>medie;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement