Skip to content

Commit bcffd73

Browse files
Update Count_Salary_Categories.sql
1 parent 4f40f45 commit bcffd73

File tree

1 file changed

+5
-0
lines changed

1 file changed

+5
-0
lines changed

Advanced_Select_and_Joins/Count_Salary_Categories.sql

Lines changed: 5 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -3,3 +3,8 @@ UNION
33
(SELECT "Average Salary" AS category, COUNT(*) AS accounts_count FROM accounts WHERE income BETWEEN 20000 AND 50000)
44
UNION
55
(SELECT "High Salary" AS category, COUNT(*) AS accounts_count FROM accounts WHERE income > 50000)
6+
7+
8+
9+
10+
--Rakshit Gupta

0 commit comments

Comments
 (0)