Accounts Above Net Balance Threshold

EASY10 pts

A digital banking platform stores customer profiles and transaction events.

Table: users

account: unique account identifier
name: account holder name

Table: transactions

trans_id: unique transaction identifier
account: account impacted by this transaction
amount: signed amount change for the account
transacted_on: calendar date for the transaction

Balance semantics:

Every account begins at 0.
Positive amount values increase balance.
Negative amount values decrease balance.
Net balance is the sum of all amount values recorded for that account.

Task: Return account holders whose net balance is strictly greater than 10000.

Output requirements:

Return columns in this exact order:
- name
- balance
Order by name ascending.

Supported submission environments:

SQL (SQLite 3.27.2)
Pandas (Python)

Example

Input

users:
| account | name    |
|---------|---------|
| 900001  | Alice   |
| 900002  | Bob     |
| 900003  | Charlie |

transactions:
| trans_id | account | amount | transacted_on |
|----------|---------|--------|---------------|
| 1        | 900001  | 7000   | 2020-08-01    |
| 2        | 900001  | 7000   | 2020-09-01    |
| 3        | 900001  | -3000  | 2020-09-02    |
| 4        | 900002  | 1000   | 2020-09-12    |
| 5        | 900003  | 6000   | 2020-08-07    |
| 6        | 900003  | 6000   | 2020-09-07    |
| 7        | 900003  | -4000  | 2020-09-11    |

Output

[
  {"name":"Alice","balance":11000}
]

Explanation

Alice is the only user whose net balance exceeds 10000. Bob and Charlie are below the threshold.

Example

Input

users:
| account | name  |
|---------|-------|
| 1001    | Dana  |
| 1002    | Evan  |
| 1003    | Farah |

transactions:
| trans_id | account | amount | transacted_on |
|----------|---------|--------|---------------|
| 11       | 1001    | 10000  | 2024-01-01    |
| 12       | 1002    | 9000   | 2024-01-01    |
| 13       | 1002    | 1100   | 2024-01-02    |
| 14       | 1003    | 20000  | 2024-01-01    |
| 15       | 1003    | -9999  | 2024-01-03    |

Output

[
  {"name":"Evan","balance":10100},
  {"name":"Farah","balance":10001}
]

Explanation

The threshold is strict. A balance of exactly 10000 does not qualify.

Example

Input

users:
| account | name   |
|---------|--------|
| 2001    | Grace  |
| 2002    | Hector |
| 2003    | Imani  |

transactions:
| trans_id | account | amount | transacted_on |
|----------|---------|--------|---------------|
| 21       | 2001    | 7000   | 2023-05-10    |
| 22       | 2001    | 3000   | 2023-05-11    |
| 23       | 2002    | 12000  | 2023-05-10    |
| 24       | 2002    | -5000  | 2023-05-11    |

Output

[]

Explanation

Grace ends at exactly 10000 and Hector falls below after a withdrawal. Imani has no transactions, so the balance remains 0.

Accepted0/0·0% Acceptance

Constraints

1 <= number of rows in users <= 300000
0 <= number of rows in transactions <= 600000
account is unique in users
name is unique in users
trans_id is unique in transactions
transactions.account references users.account
-1000000 <= amount <= 1000000
transacted_on is a valid date
Every account starts with balance 0
Return only rows where balance > 10000
Return exactly two columns: name, balance
For SQL submissions, use SQLite 3.27.2 semantics
For Pandas submissions, return a DataFrame with columns: name, balance

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

users =

[{"account":900001,"name":"Alice"},{"account":900002,"name":"Bob"},{"account":900003,"name":"Charlie"}]

transactions =

[{"trans_id":1,"account":900001,"amount":7000,"transacted_on":"2020-08-01"},{"trans_id":2,"account":900001,"amount":7000,"transacted_on":"2020-09-01"},{"trans_id":3,"account":900001,"amount":-3000,"transacted_on":"2020-09-02"},{"trans_id":4,"account":900002,"amount":1000,"transacted_on":"2020-09-12"},{"trans_id":5,"account":900003,"amount":6000,"transacted_on":"2020-08-07"},{"trans_id":6,"account":900003,"amount":6000,"transacted_on":"2020-09-07"},{"trans_id":7,"account":900003,"amount":-4000,"transacted_on":"2020-09-11"}]

Accounts Above Net Balance Threshold

Hints

Accounts Above Net Balance Threshold

Hints