By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
CUSTOMERID | AMOUNT | DAT | PRODUCTSIN30DAYS |
---|---|---|---|
1 | 1 | 2018-03-23 00:00:00 | 1 |
1 | 2 | 2020-03-24 00:00:00 | 5 |
1 | 3 | 2020-03-24 00:00:00 | 5 |
1 | 2 | 2020-03-25 00:00:00 | 7 |
1 | 2 | 2020-05-24 00:00:00 | 2 |
1 | 1 | 2020-06-15 00:00:00 | 3 |
2 | 7 | 2017-03-24 00:00:00 | 7 |
2 | 2 | 2020-03-24 00:00:00 | 2 |