​ Structure of the ORDERS Table

question 21

Multiple Choice

​
Structure of the ORDERS table
Structure of the CUSTOMERS table
​
-Which of the following SQL statements will list the name of each customer stored in the customers table,and,if the customer has placed an order that is contained in the ORDERS table,the order# of any order each customer has placed?​

• A) SELECT lastname,firstname,order# FROM orders RIGHT OUTER JOIN customers USING (customer#);
• B) SELECT lastname,firstname,order# FROM orders LEFT OUTER JOIN customers USING (customer#);
• C) SELECT lastname,firstname,order# FROM orders FULL OUTER JOIN customers USING (customer#);
• D) ​both a and c

---

Definitions:

Random Selection

A method of selecting individuals or units in such a way that each member of the population has an equal chance of being selected.

Blocking Variable

A variable that is used to group experimental units in a way that reduces variation in the response variable.

Weather

The condition of the atmosphere at a particular place and time, including temperature, humidity, wind, and precipitation.

Grazing Varieties

Types or breeds of animals or plants that are particularly suited or used for grazing, affecting ecosystems and agricultural practices.