Account Count by Income Tier

Easy

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 1

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 2

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 3

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.

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

Loading problem...

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

Account Count by Income Tier

Easy

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 1

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 2

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 3

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.

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