Account Count by Income Tier

EASY10 pts

A retail banking analytics team needs a compact monthly distribution report that groups accounts by income tier.

Table: Accounts

account_id: unique identifier of an account
income: monthly income associated with the account

Income tier rules:

"Low Salary" if income is strictly less than 20000
"Average Salary" if income is between 20000 and 50000 inclusive
"High Salary" if income is strictly greater than 50000

Task: Return the number of accounts that fall into each income tier.

Output requirements:

Return exactly two columns:
- category
- accounts_count
The result must always include all three categories.
If a category has no matching accounts, return 0 for that category.
Output order may be arbitrary.

Supported submission environments:

SQL (SQLite 3.27.2)
Pandas (Python)

Example

Input

Accounts:
| account_id | income |
|------------|--------|
| 3          | 108939 |
| 2          | 12747  |
| 8          | 87709  |
| 6          | 91796  |

Output

[
  {"category":"Low Salary","accounts_count":1},
  {"category":"Average Salary","accounts_count":0},
  {"category":"High Salary","accounts_count":3}
]

Explanation

Only account 2 is below 20000, none are in the inclusive [20000, 50000] band, and the remaining three accounts are above 50000.

Example

Input

Accounts:
| account_id | income |
|------------|--------|
| 11         | 20000  |
| 12         | 50000  |
| 13         | 19999  |
| 14         | 50001  |
| 15         | 32000  |

Output

[
  {"category":"Low Salary","accounts_count":1},
  {"category":"Average Salary","accounts_count":3},
  {"category":"High Salary","accounts_count":1}
]

Explanation

Boundary values 20000 and 50000 belong to Average Salary. Value 19999 is Low Salary and 50001 is High Salary.

Example

Input

Accounts:
| account_id | income |
|------------|--------|
| (no rows)  |

Output

[
  {"category":"Low Salary","accounts_count":0},
  {"category":"Average Salary","accounts_count":0},
  {"category":"High Salary","accounts_count":0}
]

Explanation

Even with no accounts, all three categories must be present with zero counts.

Accepted0/0·0% Acceptance

Constraints

0 <= number of rows in Accounts <= 300000
Accounts.account_id values are unique
0 <= account_id <= 1000000000
0 <= income <= 1000000000
Use tier boundaries exactly as specified
Return exactly two columns: category, accounts_count
Result must include all three categories
Use SQLite 3.27.2 semantics for SQL submissions
For Pandas submissions, return a DataFrame with columns: category, accounts_count

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

Accounts =

[{"account_id":3,"income":108939},{"account_id":2,"income":12747},{"account_id":8,"income":87709},{"account_id":6,"income":91796}]

Account Count by Income Tier

Hints

Account Count by Income Tier

Hints