Contents

Customers Who Never Order

   Jan 22, 2023     0 min read

Customers Who Never Order

문제

183-1.jpg
183-2.jpg

코드

Oracle

SELECT CUSTOMERS.NAME AS Customers
FROM CUSTOMERS
    LEFT JOIN ORDERS ON CUSTOMERS.ID = ORDERS.CUSTOMERID
WHERE ORDERS.ID IS NULL