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

James Bailey · Accepted Answer

Final Answer : B, Explanation :  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 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

Definitions

Learning Objectives

Learning Objectives

Related questions

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 = SalesRepB) WHERE OrderStatus = PendingC) WHERE CustomerStatus = ActiveD) WHERE SalesRep = Kim

Definitions

Learning Objectives

Learning Objectives

Related questions

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