By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
transaction_id | customer_id | date | previous_1hour | previous_1day | previous_1week |
---|---|---|---|---|---|
1 | 1 | 2023-01-10 01:00:00 | 1 | 1 | 3 |
3 | 1 | 2023-01-09 00:57:00 | 0 | 0 | 1 |
5 | 2 | 2023-01-10 00:57:00 | 0 | 0 | 0 |
transaction_id | customer_id | date | previous_1hour | previous_1day | previous_1week |
---|---|---|---|---|---|
1 | 1 | 2023-01-10 01:00:00 | 1 | 1 | 3 |
3 | 1 | 2023-01-09 00:57:00 | 0 | 0 | 1 |
5 | 2 | 2023-01-10 00:57:00 | 0 | 0 | 0 |