# 1873. 计算特殊奖金
# https://leetcode-cn.com/problems/calculate-special-bonus/

# SQL架构
Create table If Not Exists Employees (employee_id int, name varchar(30), salary int);
Truncate table Employees;
insert into Employees (employee_id, name, salary) values ('2', 'Meir', '3000');
insert into Employees (employee_id, name, salary) values ('3', 'Michael', '3800');
insert into Employees (employee_id, name, salary) values ('7', 'Addilyn', '7400');
insert into Employees (employee_id, name, salary) values ('8', 'Juan', '6100');
insert into Employees (employee_id, name, salary) values ('9', 'Kannon', '7700');

# Write your MySQL query statement below
select
    employee_id,
    case
        when (employee_id % 2 = 1)
        and name not like 'M%' then salary
        else 0
    end as bonus
from
    Employees
order by
    employee_id;

# clean-up
drop table Employees;