题目如下
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.
Table: Customers.
Id Name 1 Joe 2 Henry 3 Sam 4 Max Table: Orders.
Id CustomerId 1 3 2 1 Using the above tables as example, return the following:
Customers Henry Max
题目意思: 选出没有订单的用户
解题思路: 选出不在order中存在的用户
select Name
from Customers c
where not exists (
select 1 from Orders where c.Id=CustomerId);