<reponame>nikhilbhatewara/Leetcode<filename>customers-who-never-orders.sql<gh_stars>0
# Write your MySQL query statement below
SELECT  name as Customers
from customers c
left join orders o
on c.id = o.CustomerId 
where o.CustomerId is Null;


# Faster solution
select Name as Customers from Customers where Id not in (select CustomerId from Orders);

