#1873 Calculate Special Bonus

SELECT employee_id,
    CASE 
        WHEN employee_id % 2 <> 0 AND name NOT LIKE 'M%' THEN salary
        ELSE 0
    END AS bonus
FROM Employees

Last updated 3 years ago

Was this helpful?

SELECT employee_id,
    CASE 
        WHEN employee_id % 2 <> 0 AND name NOT LIKE 'M%' THEN salary
        ELSE 0
    END AS bonus
FROM Employees