mysql if关键字

 一个雇员的id是奇数并且他的名字不是以'M'开头，那么他的奖金是他工资的100%，否则奖金为0。

# Write your MySQL query statement below

select
    employee_id,
    if(    
        employee_id%2=1 and name not like 'M%',
        salary,
        0
    ) as bonus  #类似于一个三元表达式：如果这一行employee_id%2=1 and name not like 'M%',就取salary,否则就为0
from employees
order by employee_id;