72

Branch-wise Deposits

MediumJOINSUMWHERE

Problem Description

Write a SQL query to find total credits received at each branch.

Expected Columns

branch
total_deposits

Example Output

| branch | total_deposits | |--------|----------------| | Mumbai Main | 50000 | | Chennai Central | 35000 | | ... | ... |

Hints

Unlocks after 2 more attempts

Submit your solution to unlock hints

Related Topics

JOINSUMWHEREGROUP BY

//#72 Branch-wise Deposits

Medium

Loading schema...

Loading editor...

No results yet

Run a query to see results