Accounts Above Net Balance Threshold

Easy

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 1

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 2

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 3

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.

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

Loading problem...

Preparing your editor. You can read the problem while it loads.

Accounts Above Net Balance Threshold

Easy

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 1

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 2

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 3

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.

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