By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| idlote | cargo | abono | fechamovto |
|---|---|---|---|
| 2 | 0 | 5000 | 2019-11-01 |
| 1 | 1000 | 0 | 2019-12-01 |
| 2 | 4000 | 0 | 2019-11-01 |
| 1 | 2000 | 0 | 2020-01-01 |
| 2 | 0 | 500 | 2020-10-02 |
| 3 | 4000 | 0 | 2020-01-01 |
| 4 | 5000 | 0 | 2020-01-01 |
| 1 | 2000 | 0 | 2020-01-01 |
| 2 | 0 | 2000 | 2020-04-02 |
| IDLOTE | saldo |
|---|---|
| 1 | 4000 |
| 3 | 4000 |
| 4 | 5000 |