Leetcode Problem 1873. Calculate Special Bonus

1873. Calculate Special Bonus

Leetcode Solutions

Check if the employee_id is an odd number using the modulo operator % 2.
Check if the name does not start with 'M' using the NOT REGEXP '^M' in SQL or startswith('M') in Pandas.
Use the IF function in SQL or a lambda function in Pandas to assign the bonus based on the conditions.
In SQL, select employee_id and the calculated bonus, ordering the results by employee_id.
In Pandas, apply the lambda function across the DataFrame using apply with axis=1, create a new bonus column, and sort the DataFrame by employee_id.

erDiagram
    Employees {
        int employee_id PK
        varchar name
        int salary
    }

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen