By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
| dt | user_id | amount_actions | wk | rolling_sum_7_days |
|---|---|---|---|---|
| 2018-12-01 | 1 | 2 | 482018 | 2 |
| 2018-12-02 | 1 | 1 | 482018 | 3 |
| 2018-12-10 | 1 | 1 | 502018 | 1 |
| 2018-12-01 | 2 | 2 | 482018 | 2 |
| 2018-12-02 | 2 | 1 | 482018 | 3 |
| 2018-12-10 | 3 | 1 | 502018 | 1 |