리트코드(LeetCode) SQL - 1873. Calculate Special Bonus

진한색 2023. 1. 4. 21:42

select employee_id,IF(employee_id%2=1 and name NOT like "M%",salary,0) as bonus
    from Employees
    order by 1

728x90