Advertisement
Guest User

Untitled

a guest
Oct 28th, 2016
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.30 KB | None | 0 0
  1. with counted as (
  2. select
  3.     m.id as manager_id
  4.     , m.name
  5.     , m.chief_id
  6.     , count(c.id) as claims
  7. from manager m
  8. join claim c
  9.     on m.id = c.manager_id
  10. group by
  11.     m.id
  12.     , m.chief_id
  13.     , m.name
  14. )
  15. select
  16.     m.name
  17. from counted m
  18. left join counted c
  19.     on m.chief_id = c.manager_id
  20. where m.claims > c.claims
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement