题目链接：点击打开链接
题目大意：略。
解题思路：略。
AC 代码
-- 解决方案(1) 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; -- 解决方案(2) SELECT employee_id, IF(LEFT(name, 1) <> 'M' AND employee_id MOD 2 = 1, salary, 0) bonus FROM Employees
