Kim Is Writing a SQL Query That Will Pull a List

question 820

Multiple Choice

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:

Service Department Charge Rate

The rate at which internal service departments charge other parts of the same organization for the services rendered.

Accounting Department

The division within a company responsible for managing financial records, ensuring compliance with accounting standards, and producing financial statements.

Service Department Cost

Involves the expenses associated with the departments that do not directly produce goods but provide support or services to other departments within an organization.

ABC Corporation

A hypothetical or generic naming convention used to represent a company in examples or case studies.