SQL

no customers ordered

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


select customers.name as 'Customers'
from customers
where customers.id not in
(
    select customerid from orders
);