183. 从不订购的客户 + 多表查询

183. 从不订购的客户

LeetCode_MySql_183

题目描述

代码实现

# Write your MySQL query statement below
select Name as 'Customers'
from Customers
where Customers.Id not in
(
    select CustomerId from Orders
);
posted @ 2021-03-02 19:14  Garrett_Wale  阅读(43)  评论(0编辑  收藏  举报