力扣---高频SQL题---36---1907. 按分类统计薪水

一、题目

二、代码

select "High Salary" as category ,count(account_id) as accounts_count from Accounts 
where income > 50000
union
select "Low Salary" as category ,count(account_id) as accounts_count from Accounts 
where income < 20000
union
select "Average Salary" as category ,count(account_id) as accounts_count from Accounts 
where income >=20000  and income<=50000

三、运行结果