In this guide, you will get 1907. Count Salary Categories LeetCode Solution with the best time and space complexity. The solution to Count Salary Categories problem is provided in various programming languages like C++, Java, and Python. This will be helpful for you if you are preparing for placements, hackathons, interviews, or practice purposes. The solutions provided here are very easy to follow and include detailed explanations.
+————-+——+
| Column Name | Type |
+————-+——+
| account_id | int |
| income | int |
+————-+——+
account_id is the primary key (column with unique values) for this table.
Each row contains information about the monthly income for one bank account.
Write a solution to calculate the number of bank accounts for each salary category. The salary categories are:
“Low Salary”: All the salaries strictly less than $20000.
“Average Salary”: All the salaries in the inclusive range [$20000, $50000].
“High Salary”: All the salaries strictly greater than $50000.
The result table must contain all three categories. If there are no accounts in a category, return 0.
Return the result table in any order.
The result format is in the following example.
Example not found
Constraints not found
Complexity Analysis
Time Complexity: Google AdSense
Space Complexity: Google Analytics
1907. Count Salary Categories LeetCode Solution in C++
SELECT
'Low Salary' AS Category,
SUM(income < 20000) AS accounts_count
FROM Accounts
UNION ALL
SELECT
'Average Salary' Category,
SUM(income >= 20000 AND income <= 50000) AS accounts_count
FROM Accounts
UNION ALL
SELECT
'High Salary' category,
SUM(income > 50000) AS accounts_count
FROM Accounts; /* code provided by PROGIEZ */
1907. Count Salary Categories LeetCode Solution in Java
N/A // code provided by PROGIEZ
1907. Count Salary Categories LeetCode Solution in Python
