183. Customers Who Never Order

SELECT c.Name AS Customers
FROM Customers c
LEFT JOIN Orders o
ON c.Id = o.CustomerId
WHERE o.Id IS NULL

posted @ 2018-12-20 03:06  yuesi  阅读(84)  评论(0编辑  收藏  举报