By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
| id | avg |
|---|---|
| 1 | 2.5 |
| 2 | 3.2 |
| 3 | 4.1 |
| 4 | 0.8 |
| id | avg | daily_avg |
|---|---|---|
| 1 | 2.5 | 2.6500000000000000 |
| 2 | 3.2 | 2.6500000000000000 |
| 3 | 4.1 | 2.6500000000000000 |
| 4 | 0.8 | 2.6500000000000000 |