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 |