By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ItemName | Plus | Mins | Price | movingAvg |
---|---|---|---|---|
Iphone 13 | 5 | 0 | 500000 | 500000.000000 |
Iphone 13 | 0 | 1 | 700000 | 500000.000000 |
Iphone 13 | 0 | 1 | 750000 | 500000.000000 |
Iphone 13 | 3 | 0 | 600000 | 537500.000000 |
Iphone 13 | 0 | 1 | 700000 | 537500.000000 |
Iphone 13 | 0 | 1 | 750000 | 537500.000000 |
Warning: Null value is eliminated by an aggregate or other SET operation.