1873. Calculate Special Bonus.sql

/* Write your PL/SQL 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 1