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:

Job Applicant

An individual who applies for a position of employment in a company or organization.

Online Search

The process of using internet-based tools and platforms to obtain information or find resources.

Corporate Social Responsibility

A business model that helps a company be socially accountable to itself, its stakeholders, and the public.

Responsibility of Citizenship

The duties and obligations that come with being a member of a community or country, including obeying laws, paying taxes, and participating in civic life.