Advertisement
Guest User

Untitled

a guest
Nov 14th, 2019
136
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. with depsum as (select sum(salary) sumsal,department_id, department_name
  2. from employees join departments using(department_id)
  3. where department_id is not null
  4. group by department_id),
  5. avgsumsal as (select avg(sumsal) medie
  6. from depsum)
  7. select department_name,sumsal
  8. from depsum,avgsumsal
  9. where sumsal>medie;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement