8000 🟡 Solve problem 1907 · AF2B/Leetcode@72989fa · GitHub
[go: up one dir, main page]
Skip to content

Commit 72989fa

Browse files
AF2BAF2B
committed
🟡 Solve problem 1907
1 parent 767ac33 commit 72989fa

File tree

1 file changed

+16
-0
lines changed

1 file changed

+16
-0
lines changed

‎sql/1907.sql

Lines changed: 16 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,16 @@
1+
WITH Categories AS (
2+
SELECT 'Low Salary' AS category
3+
UNION ALL
4+
SELECT 'Average Salary'
5+
UNION ALL
6+
SELECT 'High Salary'
7+
)
8+
SELECT
9+
C.category,
10+
COUNT(A.income) AS accounts_count
11+
FROM Categories C
12+
LEFT JOIN Accounts A
13+
ON (C.category = 'Low Salary' AND A.income < 20000)
14+
OR (C.category = 'Average Salary' AND A.income BETWEEN 20000 AND 50000)
15+
OR (C.category = 'High Salary' AND A.income > 50000)
16+
GROUP BY C.category;

0 commit comments

Comments
 (0)
0