题目链接:点击打开链接
题目大意:略。
解题思路:略。
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