LeetCode 183. Customers Who Never Order (从不订购的客户)

题目标签：

　　题目给了我们 Customers 和 Orders 两个表格，让我们找到 从没订购过的客户。

　　首先从Orders 得到 订购过的CustomerId，然后再去Customers 里找 没有出现过的 Id，返回名字。

 

Java Solution:

Runtime:  264 ms, faster than 53 % 

Memory Usage: N/A

完成日期：06/01/2019

关键点：NOT IN

# Write your MySQL query statement below
SELECT Customers.Name AS Customers
FROM Customers
WHERE Customers.Id NOT IN (SELECT CustomerId FROM Orders);

参考资料：n/a

LeetCode 题目列表 - LeetCode Questions List

题目来源：https://leetcode.com/

转载于:https://www.cnblogs.com/jimmycheng/p/11444496.html