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

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
-- @Title: 从不订购的客户 (Customers Who Never Order)
-- @Author: 15816537946@163.com
-- @Date: 2021-03-03 15:24:43
-- @Runtime: 381 ms
-- @Memory: 0 B
# Write your MySQL query statement below


select 
C1.Name AS Customers
from
Customers C1 
left join Orders O
on C1.Id = O.CustomerId
where O.CustomerId is NULL;