1873-calculate-special-bonus.sql

-- Title: Calculate Special Bonus
-- Description:
--     Write an SQL query to calculate the bonus of each employee.
--     The bonus of an employee is 100% of their salary if the ID of the employee is an odd number and the employee name does not start with the character 'M'.
--     The bonus of an employee is 0 otherwise.
--     Return the result table ordered by employee_id.
-- Link: https://leetcode.com/problems/calculate-special-bonus/

-- Write your MySQL query statement below
SELECT
    employee_id,
    CASE
        WHEN (MOD(employee_id, 2) <> 0) AND (name NOT LIKE 'M%') THEN
            salary
        ELSE
            0
    END AS bonus
FROM Employees
ORDER BY employee_id