48

Total Bank Deposits

MediumJOINSUMWHERE

Problem Description

Write a SQL query to find total credit amount per account.

Expected Columns

  • holder_name
  • total_credits

Example Output

| holder_name | total_credits | |-------------|---------------| | Vijay Anand | 50000 | | Shobha Rani | 35000 | | ... | ... |

Hints

Unlocks after 2 more attempts
Submit your solution to unlock hints

Related Topics

JOINSUMWHEREGROUP BY
//#48 Total Bank Deposits
Medium

Loading schema...

Loading editor...

No results yet

Run a query to see results