文章目录
-
- 原题题目
- 代码实现(首刷自解)
原题题目
代码实现(首刷自解)
# Write your MySQL query statement below
SELECT employee_id,if(employee_id%2 = 0 or name like 'M%',0,salary) bonus
FROM employees
# Write your MySQL query statement below
SELECT employee_id,if(employee_id%2 = 0 or name like 'M%',0,salary) bonus
FROM employees