You have two tables named Customer and SalesOrder. You need to identify all customers that have not yet made any purchases and those that have only made orders with an OrderTotal less than 100.
Which query should you use?
A. SELECT *
FROM Customer
WHERE 100 > SOME (SELECT OrderTotal
FROM SalesOrder
WHERE Customer.CustomerID = SalesOrder.CustomerID)
B. SELECT *
FROM Customer
WHERE EXISTS (SELECT SalesOrder.CustomerID
FROM SalesOrder
WHERE Customer.CustomerID = SalesOrder.CustomerID
AND SalesOrder.OrderTotal <= 100)
C. SELECT *
FROM Customer
WHERE 100 > ALL (SELECT OrderTotal
FROM SalesOrder
WHERE Customer.CustomerID = SalesOrder.CustomerID)
D. SELECT *
FROM Customer
WHERE 100 > (SELECT MAX(OrderTotal)
FROM SalesOrder
WHERE Customer.CustomerID = SalesOrder.CustomerID)
