-
183. Customers Who Never Order mysqlLeetCode_Study_Plan/SQL 2022. 9. 25. 16:01
https://leetcode.com/problems/customers-who-never-order/?envType=study-plan&id=sql-i
select c.name as Customers from customers as c left join orders as o on c.Id = o.customerId where o.id is null;
'LeetCode_Study_Plan > SQL' 카테고리의 다른 글
627. Swap Salary mysql (0) 2022.09.26 1873. Calculate Special Bonus mysql (0) 2022.09.26 584. Find Customer Referee mysql (0) 2022.09.25 1757. Recyclable and Low Fat Products mysql (1) 2022.09.25 595. Big Countries mysql (1) 2022.09.25