By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| REF_NO | CUS_NO | AMOUNT | DATER |
|---|---|---|---|
| AA1 | 123 | 200000 | 20190405 |
| AA1 | 123 | 2657915 | 20190322 |
| AA1 | 123 | 317085 | 20190402 |
| AA1 | 123 | 325000 | 20190522 |
| AA2 | 265 | 1000000 | 20190125 |
| AA2 | 265 | 1500000 | 20190102 |
| AA3 | 457 | 475000 | 20190101 |