4. Customers Who Never Order (183)

👉https://leetcode.com/problems/customers-who-never-order/?envType=study-plan&id=sql-i

Customers Who Never Order - LeetCode

---

🤔 문제 분석

1) Write an SQL query to report all customers who never order anything.

 

💡 풀이

SELECT Customers.Name AS Customers
FROM Customers
    LEFT JOIN Orders ON Customers.id = Orders.customerid
WHERE Orders.id is null