题目分析:一个包含Customers的顾客表和Orders的订单表,两个表。通过SQL找到从没有过订单的顾客。可以用NOT IN,NOT EXISTS。
SQL语句:
1.使用NOT IN(Accepted 777ms):
SELECT Name FROM Customers c WHERE c.Id NOT IN (SELECT CustomerId FROM Orders o);
2.使用NOT EXISTS(Accepted 745ms):
SELECT Name FROM Customers c WHERE NOT EXISTS (SELECT CustomerId FROM Orders o WHERE o.CustomerId = c.id)