WA:
select Customers.Name as Customers from Customers where Customers.Name not in (select Customers.Name from Customers join Orders on Customers.Id = Orders.CustomerId) ;
AC:
select Customers.Name as Customers from Customers where Customers.Id not in (select Customers.Id from Customers join Orders on Customers.Id = Orders.CustomerId) ;
Leetcode Customers Who Never Order
最新推荐文章于 2019-03-10 15:52:33 发布