Which of the following statements returns orders smaller than the largest order
ID: 3576223 • Letter: W
Question
Which of the following statements returns orders smaller than the largest order for Customer 1199? SELECT CustomerName, OrderNumber, OrderTotal FROM Customers JOIN Orders ON Customers.CustomerID = Orders.CustomerID WHERE OrderTotal > ANY (SELECT OrderTotal FROM Orders WHERE CustomerID = 1199) SELECT CustomerName, OrderNumber, OrderTotal FROM Customers JOIN Orders ON Customers.CustomerID = Orders.CustomerID WHERE OrderTotal > NONE (SELECT OrderTotal FROM Orders WHERE CustomerID = 1199) SELECT CustomerName, OrderNumber, OrderTotal FROM Customers JOIN Orders ON Customers.CustomerID = Orders.CustomerID WHERE OrderTotalExplanation / Answer
which of the following statements returns orders smaller than largest order of the customer 1199?
Answer : option -- D
select CustomerName,OrderNumber,OrderTotal
FROM Customers Join Orders On Customers.Customer ID=order.customerID
WHERE OrderTotal<ALL
(SELECT Order Total
FROM Orders
WHERE Customer ID=1199)