​ Structure of the ORDERS Table

question 85

Multiple Choice

​
Structure of the ORDERS table
Structure of the CUSTOMERS table
​
-​Which of the following SQL statements will return the names of all customers who placed an order on April 12,2003?

• A) SELECT lastname,firstname FROM customers WHERE orderdate = '12-APR-03';
• B) SELECT lastname,firstname FROM customers NATURAL JOIN orders WHERE orderdate = '12-APR-03';
• C) SELECT lastname,firstname FROM customers JOIN orders ON (customer#) WHERE orderdate = '12-APR-03';
• D) ​both a and b

---

Definitions:

Down Syndrome

A genetic disorder caused by the presence of all or part of a third copy of chromosome 21, characterized by developmental delays and physical features such as a flat facial profile.

Genetic Disorders

Diseases or conditions that result from abnormalities in an individual's DNA, often inherited from one's parents.

Trisomy

Chromosome condition in which a diploid cell has one more chromosome than normal; designated as 2n + 1.

Extra Copy

In genetics, refers to an additional copy of a gene or chromosome segment, potentially leading to variations in traits or disease susceptibility.