https://leetcode.com/problems/calculate-special-bonus/submissions/



Runtime: 661 ms, faster than 32.69% of MySQL online submissions for Calculate Special Bonus.

Memory Usage: 0B, less than 100.00% of MySQL online submissions for Calculate Special Bonus.



```mysql
# copied to know the knowledge
SELECT employee_id,
       IF(employee_id%2 = 1
          #AND name NOT LIKE('M%'), salary, 0) AS bonus
          AND left(name, 1) != 'M', salary, 0) AS bonus
FROM Employees;
```