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