코딩코딩코딩

[LeetCode] 183. Customers Who Never Order 본문

MySQL/Problem Solving

[LeetCode] 183. Customers Who Never Order

hanshow113 2022. 2. 6. 20:35

 

SELECT Customers.name AS Customers
FROM Customers
     LEFT JOIN Orders ON Customers.id = Orders.CustomerId
WHERE CustomerId IS NULL

'MySQL > Problem Solving' 카테고리의 다른 글

[HackerRank] Average Population of Each Continent  (0) 2022.02.06
[HackerRank] African Cities  (0) 2022.02.06
[HackerRank] Population Census  (0) 2022.02.06
[LeetCode] 1179.Reformat Department Table, MySQL 피봇테이블  (0) 2022.02.06
[HackerRank] Type of Triangle  (0) 2022.01.18
'MySQL/Problem Solving' Related Articles more
Comments