0
Given ORDERS(OrderID, CustID, Amount) and CUSTOMERS(CustID, CustName), which SQL query finds the names of customers who have placed NO orders?
- ASELECT CustName FROM Customers C JOIN Orders O ON C.CustID = O.CustID WHERE O.OrderID IS NULL;
- BSELECT CustName FROM Customers C LEFT JOIN Orders O ON C.CustID = O.CustID WHERE O.OrderID IS NULL;
- CSELECT CustName FROM Customers WHERE CustID IN (SELECT CustID FROM Orders);
- DSELECT CustName FROM Customers C, Orders O WHERE C.CustID = O.CustID;
Correct answer: B