Customers Who Never Order
문제


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


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