1873.sql (137B)
1 SELECT employee_id, IF(employee_id % 2 = 1 AND UPPER(SUBSTR(name, 1, 1)) != 'M', salary, 0) AS bonus 2 FROM Employees 3 ORDER BY employee_id