Combined Client Balance
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). Clients who have no accounts yet must appear as well, with a balance of 0. 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. Your answer must use the same column names as this sample — alias them with AS if needed.
| 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