[LeetCode] 1907. Count Salary Categories

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

SELECT 'Low Salary' AS category
     , COUNT(*) AS accounts_count
FROM Accounts
WHERE income < 20000

UNION

SELECT 'Average Salary' AS category
     , COUNT(*) AS accounts_count
FROM Accounts
WHERE income >= 20000 AND income <= 50000

UNION

SELECT 'High Salary' AS category
     , COUNT(*) AS accounts_count
FROM Accounts
WHERE income > 50000