MySQL刷题1| 1821. 寻找今年具有正收入的客户、1873. 计算特殊奖金、183. 从不订购的客户

1821. 寻找今年具有正收入的客户

题目连接：1821. 寻找今年具有正收入的客户 - 力扣（LeetCode）

# Write your MySQL query statement belo
SELECT customer_id
FROM Customers
WHERE revenue > 0 AND year = 2021
GROUP BY customer_id;

1873. 计算特殊奖金

题目连接：1873. 计算特殊奖金 - 力扣（LeetCode）

# Write your MySQL query statement below
select employee_id, case when name like 'M%' or employee_id % 2 = 0
                        then 0
                        else salary
                        END as 'bonus'
from Employees
order by employee_id

183. 从不订购的客户

题目连接：183. 从不订购的客户 - 力扣（LeetCode）

# Write your MySQL query statement below
select c.name Customers
from Customers c
where c.id not in (
select customerID
from Orders
)