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:

Genetic Variation

The diversity in gene frequencies within a population, which contributes to differences among individuals.

Random Assortment

The process during meiosis where chromosomes are randomly segregated to gametes, contributing to genetic variation.

Chromosomes

Structures found within the nucleus of a cell, made of DNA and proteins, that contain the genetic information necessary for the growth, development, and reproduction of organisms.

Crossing Over

A process during meiosis where two chromosomes pair up and exchange segments of their genetic material to produce recombinant chromosomes.