count-salary-categories

java

python

python3

mysql

mssql

oraclesql

csharp

javascript

typescript

bash

swift

kotlin

dart

golang

ruby

scala

rust

racket

erlang

elixir

pythondata

postgresql

cangjie

Database

Table: <code>Accounts</code>

<pre>
+-------------+------+
| Column Name | Type |
+-------------+------+
| account_id | int |
| income | int |
+-------------+------+
account_id is the primary key (column with unique values) for this table.
Each row contains information about the monthly income for one bank account.
</pre>

&nbsp;

Write a solution&nbsp;to calculate the number of bank accounts for each salary category. The salary categories are:

<ul>
	<li><code>&quot;Low Salary&quot;</code>: All the salaries strictly less than <code>$20000</code>.</li>
	<li><code>&quot;Average Salary&quot;</code>: All the salaries in the inclusive range <code>[$20000, $50000]</code>.</li>
	<li><code>&quot;High Salary&quot;</code>: All the salaries strictly greater than <code>$50000</code>.</li>
</ul>

The result table must contain all three categories. If there are no accounts in a category,&nbsp;return&nbsp;<code>0</code>.

Return the result table in any order.

The&nbsp;result format is in the following example.

&nbsp;
Example 1:

<pre>
Input: 
Accounts table:
+------------+--------+
| account_id | income |
+------------+--------+
| 3 | 108939 |
| 2 | 12747 |
| 8 | 87709 |
| 6 | 91796 |
+------------+--------+
Output: 
+----------------+----------------+
| category | accounts_count |
+----------------+----------------+
| Low Salary | 1 |
| Average Salary | 0 |
| High Salary | 3 |
+----------------+----------------+
Explanation: 
Low Salary: Account 2.
Average Salary: No accounts.
High Salary: Accounts 3, 6, and 8.
</pre>

count_salary_categories

Count Salary Categories

Create a Session Bar Chart

create-a-session-bar-chart

制作会话柱状图

表: <code>Accounts</code>

<pre>
+-------------+------+
| 列名 | 类型 |
+-------------+------+
| account_id | int |
| income | int |
+-------------+------+
在 SQL 中，account_id&nbsp;是这个表的主键。
每一行都包含一个银行帐户的月收入的信息。
</pre>

&nbsp;

查询每个工资类别的银行账户数量。&nbsp;工资类别如下：

<ul>
	<li><code>"Low Salary"</code>：所有工资 严格低于 <code>20000</code> 美元。</li>
	<li><code>"Average Salary"</code>： 包含 范围内的所有工资&nbsp;<code>[$20000,&nbsp;$50000]</code> 。</li>
	<li>
	<code>"High Salary"</code>：所有工资 严格大于 <code>50000</code> 美元。
	</li>
</ul>

结果表 必须 包含所有三个类别。&nbsp;如果某个类别中没有帐户，则报告&nbsp;<code>0</code> 。

按 任意顺序 返回结果表。

查询结果格式如下示例。

&nbsp;

示例 1：

<pre>
输入：
Accounts 表:
+------------+--------+
| account_id | income |
+------------+--------+
| 3 | 108939 |
| 2 | 12747 |
| 8 | 87709 |
| 6 | 91796 |
+------------+--------+
输出：
+----------------+----------------+
| category | accounts_count |
+----------------+----------------+
| Low Salary | 1 |
| Average Salary | 0 |
| High Salary | 3 |
+----------------+----------------+
解释：
低薪: 有一个账户 2.
中等薪水: 没有.
高薪: 有三个账户，他们是 3, 6和 8.</pre>