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:

Stockholders' Equity

The residual interest in the assets of a corporation after deducting liabilities, representing the ownership interest of the shareholders.

Stock Warrants

Financial instruments that give the holder the right to purchase the issuer's stock at a specified price before a specified date.

Compensation Expense

Costs associated with the wages, salaries, and benefits provided to employees, recorded on the income statement.

Service Period

The period of time over which employee services are rendered in exchange for an award, common in the context of stock compensation plans.