By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| EMP_ID | POS | MGR_ID | CNT |
|---|---|---|---|
| 1 | President | null | 2 |
| 100 | mgr1 | 1 | 3 |
| 200 | mgr2 | 1 | 2 |
| 1001 | emp11 | 100 | 0 |
| 1002 | emp12 | 100 | 0 |
| 1003 | emp13 | 100 | 0 |
| 2001 | emp21 | 200 | 0 |
| 2002 | emp22 | 200 | 0 |
| EMP_ID | POS | MGR_ID | CNT |
|---|---|---|---|
| 1 | President | null | 2 |
| 100 | mgr1 | 1 | 3 |
| 200 | mgr2 | 1 | 2 |
| 1001 | emp11 | 100 | 0 |
| 1002 | emp12 | 100 | 0 |
| 1003 | emp13 | 100 | 0 |
| 2001 | emp21 | 200 | 0 |
| 2002 | emp22 | 200 | 0 |