tcv-tclsbc
diff --git a/‎README.md
Copy file name to clipboardExpand all lines: README.md
+13Lines changed: 13 additions & 0 deletions b/‎README.md
Copy file name to clipboardExpand all lines: README.md
+13Lines changed: 13 additions & 0 deletions
@@ -503,3 +503,16 @@ SELECT *
 FROM Users
 WHERE mail REGEXP '^[A-Za-z][A-Za-z0-9_\.\-]*@leetcode\\.com$'
 ```
+
+[1907. Count Salary Categories](https://leetcode.com/problems/count-salary-categories/)
+```sql
+
+SELECT 'Low Salary' AS category, SUM(IF(income<20000,1,0)) AS accounts_count 
+FROM Accounts
+UNION
+SELECT 'Average Salary' AS category, SUM(IF(income>=20000 AND income<=50000,1,0)) AS accounts_count 
+FROM Accounts
+UNION
+SELECT 'High Salary' AS category, SUM(IF(income>50000,1,0)) AS accounts_count 
+FROM Accounts
+```