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;
|