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:

Haemophilus Bacteria

A group of bacteria that can cause various infections in humans, including respiratory infections and meningitis.

Biofilms

Complex communities of microorganisms that adhere to surfaces and are encased in a self-produced protective matrix.

Dental Plaque

A sticky film of bacteria and substances they produce, which accumulates on teeth and can lead to dental caries and gum disease if not regularly removed.

Surgical Implants

Medical devices placed inside the human body during surgery for the purpose of supporting or replacing an organ or structure.