sql easy

    183. 从不订购的客户

    思路一

    1. select Name as Customers
    2. from Customers c where Id not in (select CustomerId from Orders);

    思路二

    select c.Name as Customers
from Customers c left join Orders o
on c.Id = o.CustomerId where o.CustomerId is null;