By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ACCOUNT_NUMBER | SUM(AMOUNT_SETTLED) |
|---|---|
| 1 | 50 |
| 2 | 90 |
| SUM_AMOUNT_SETTLED | SUM_AMOUNT |
|---|---|
| 50 | 90 |
| ACCOUNT_NUMBER | SUM(AMOUNT_SETTLED) |
|---|---|
| 1 | 50 |
| 2 | 90 |
| SUM_AMOUNT_SETTLED | SUM_AMOUNT |
|---|---|
| 50 | 90 |