SELECT employee_id, IF(employee_id % 2 = 1 AND name NOT LIKE 'M%', salary, 0) AS bonus
  FROM Employees

UPDATE Salary
   SET sex = IF(sex = 'f','m','f')