Combined Client Balance
Finance is preparing a client overview. For each client, output the name and the total balance across all their accounts (total_balance). Sort by total balance descending.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.
| name | total_balance |
|---|---|
| Foster M.M. | 610000.00 |
| Peterson P.P. | 325000.00 |
| Johnson I.I. | 195000.50 |
Sberbank
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid