Customers Who Never Order
https://leetcode.com/problems/Customers-Who-Never-Order/
SELECT name AS Customers FROM Customers AS c
LEFT JOIN Orders AS o ON o.customerId = c.id
WHERE o.id is null
'기존학습자료 > leetcode, hackerrank' 카테고리의 다른 글
| Leetcode 180 - Consecutive Numbers (0) | 2023.06.24 |
|---|---|
| Leetcode 1179 - Reformat Department Table (0) | 2023.06.24 |
| Leetcode 181 - Employees Earning More Than Their Managers (0) | 2023.06.24 |
| Leetcode 197 - Rising Temperature (0) | 2023.06.24 |
| Leetcode 595 - Big Countries (0) | 2023.06.24 |