LEETCODE数据库:183.CustomersWhoNeverOrder

发表于 更新于 分类于 Waline： 阅读次数：

题目

Suppose that a website contains two tables, the Customers table and the Orders table. Write a SQL query to find all customers who never order anything.

Customers.
Id Name
1 Joe
2 Henry
3 Sam
4 Max
Orders.
Id CustomerId
1 3
2 1

Using the above tables as example, return the following:

Customers
Henry
Max

题解

1
2
3
4
5
6
7
# Write your MySQL query statement below
SELECT Customers.Name Customers
FROM Customers
WHERE Customers.Id NOT IN (
    SELECT CustomerId
    FROM Orders
);