By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 7 Duplicates: 0 Warnings: 0
| r | date | count | profit | avg_prev2 | avg_next2 |
|---|---|---|---|---|---|
| 3 | 2023-12-03 | 125 | 660 | 190.0000 | 500.0000 |
| 6 | 2023-12-06 | 150 | 710 | 500.0000 | 740.0000 |
Records: 7 Duplicates: 0 Warnings: 0
| r | date | count | profit | avg_prev2 | avg_next2 |
|---|---|---|---|---|---|
| 3 | 2023-12-03 | 125 | 660 | 190.0000 | 500.0000 |
| 6 | 2023-12-06 | 150 | 710 | 500.0000 | 740.0000 |