# 1907. Count Salary Categories

<https://leetcode.com/problems/count-salary-categories>

## Description

Table: `Accounts`

```
+-------------+------+
| Column Name | Type |
+-------------+------+
| account\_id  | int  |
| income      | int  |
+-------------+------+
account\_id is the primary key for this table.
Each row contains information about the monthly income for one bank account.
```

Write an SQL query to report the number of bank accounts of each salary category. The salary categories are:

* `"Low Salary"`: All the salaries **strictly less** than `$20000`.
* `"Average Salary"`: All the salaries in the **inclusive** range `[$20000, $50000]`.
* `"High Salary"`: All the salaries **strictly greater** than `$50000`.

The result table **must** contain all three categories. If there are no accounts in a category, then report `0`. Return the result table in **any order**.

The query result format is in the following example.

```
Accounts table:
+------------+--------+
| account\_id | income |
+------------+--------+
| 3          | 108939 |
| 2          | 12747  |
| 8          | 87709  |
| 6          | 91796  |
+------------+--------+
Result table:
+----------------+----------------+
| category       | accounts\_count |
+----------------+----------------+
| Low Salary     | 1              |
| Average Salary | 0              |
| High Salary    | 3              |
+----------------+----------------+
Low Salary: Account 2.
Average Salary: No accounts.
High Salary: Accounts 3, 6, and 8.
```

## ac

```java
```
