Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- with counted as (
- select
- m.id as manager_id
- , m.name
- , m.chief_id
- , count(c.id) as claims
- from manager m
- join claim c
- on m.id = c.manager_id
- group by
- m.id
- , m.chief_id
- , m.name
- )
- select
- m.name
- from counted m
- left join counted c
- on m.chief_id = c.manager_id
- where m.claims > c.claims
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement