By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| Id | ParentId | Name |
|---|---|---|
| 1 | null | Tom |
| 2 | 1 | Jake |
| 3 | 2 | Kate |
| 4 | 3 | Neil |
| 5 | null | Foo |
| 6 | 5 | Bar |
| PersonId | Price |
|---|---|
| 4 | 500.0 |
| 6 | 1000.0 |
| Id | ParentId | Name | sale |
|---|---|---|---|
| 1 | null | Tom | 100.000000 |
| 2 | 1 | Jake | 80.000000 |
| 3 | 2 | Kate | 64.000000 |
| 4 | 3 | Neil | 256.000000 |
| 5 | null | Foo | 200.000000 |
| 6 | 5 | Bar | 800.000000 |