Kim is writing a SQL query that will pull a list of customers with outstanding orders and the sales rep for each order.What should the WHERE phrase say in her query?
A) WHERE Customer = SalesRep
B) WHERE OrderStatus = Pending
C) WHERE CustomerStatus = Active
D) WHERE SalesRep = Kim

Question

Quizplus · Accepted Answer

The WHERE phrase should specify the condition that filters for outstanding orders. OrderStatus = Pending would indicate that the order has not been fulfilled yet. The other options do not address outstanding orders.

Kim Is Writing a SQL Query That Will Pull a List