Advertisement
1873. Calculate Special Bonus
UnknownView on LeetCode
1873.sql
MySQL
/* Write your T-SQL query statement below */
SELECT
employee_id,
CASE WHEN employee_id % 2 = 1 AND LEFT(name, 1) != 'M' THEN salary ELSE 0 END AS bonus
FROM Employees
ORDER BY 1;Advertisement
Was this solution helpful?