By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
user_id |
timestamp |
amount |
|---|---|---|
1 |
2021-06-09 00:00:00 |
111 |
1 |
2021-09-17 00:00:00 |
222 |
1 |
2021-12-26 00:00:00 |
333 |
2 |
2021-06-09 00:00:00 |
444 |
2 |
2021-09-17 00:00:00 |
555 |
3 |
2021-03-01 00:00:00 |
666 |
3 |
2021-06-09 00:00:00 |
777 |
4 |
2021-06-09 00:00:00 |
888 |
5 |
2021-09-17 00:00:00 |
999 |
user_id |
amount |
timestamp |
|---|---|---|
1 |
333 |
2021-12-26 00:00:00 |
2 |
555 |
2021-09-17 00:00:00 |
3 |
0 |
2021-06-09 00:00:00 |
4 |
0 |
2021-06-09 00:00:00 |
5 |
999 |
2021-09-17 00:00:00 |