[LeetCode] 1873. Calculate Special Bonus

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

SELECT employee_id
     , CASE WHEN MOD(employee_id, 2) = 1 AND name NOT LIKE 'M%'
                THEN salary
            ELSE 0
        END AS bonus
FROM Employees
ORDER BY employee_id ASC