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:

Securities And Exchange Commission

A U.S. federal agency responsible for regulating the securities industry, enforcing federal securities laws, and ensuring investor protection.

Financial Information

Data regarding the financial status of an entity, including income, expenses, assets, liabilities, and equity, often used for analysis.

Competitors

Entities or businesses competing in the same industry or market for customers.

Focus Group

Data-collection tool in which a moderator engages a small group of people as they discuss a particular topic or concept with each other in a spontaneous way.