1907. Count Salary Categories

• 문제
  
• 정답

SELECT 
'Low Salary' category,
SUM(income < 20000) accounts_count
FROM accounts

UNION

SELECT 
'Average Salary' category,
SUM(income >= 20000 and income <= 50000) accounts_count
FROM accounts

UNION

SELECT 
'High Salary' category,
sum(income > 50000) accounts_count
FROM accounts

• 결과