[leetcode数据库14] 183. 从不订购的客户

leetcode数据库题目，简单题，面试中出现概率约为25%

题目描述：

 

题目答案：

select a.name as Customers
from Customers a left join Orders b on a.id = b.CustomerId
where  b.id is null;

-- 官方题解
select customers.name as 'Customers'
from customers
where customers.id not in
(
    select customerid from orders
);

知识点：left join