Leetcode Problem 1907. Count Salary Categories

1907. Count Salary Categories

Leetcode Solutions

Use a CASE statement to check if the income is less than 20000, between 20000 and 50000, or greater than 50000.
Use the SUM function to count the number of accounts that fall into each category based on the CASE statement.
Use UNION to combine the results of the three categories into a single result set.
In Pandas, apply boolean indexing to filter the DataFrame for each salary range and use the sum() method to count the number of True values, which correspond to the number of accounts in each category.
Create a new DataFrame with the category names and the corresponding counts.

erDiagram
    Accounts {
        int account_id
        int income
    }

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen