​ 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:

Fertile Soil

Soil rich in nutrients and organic matter, capable of supporting vigorous plant growth.

Temperate Grasslands

Ecosystems characterized by vast open areas with relatively few trees, experiencing moderate rainfall and seasonal temperature variations, often used for grazing and agriculture.

Tropical Deciduous Forest

A biome classified by trees that shed their leaves in dry seasons, found in tropical regions with seasonal rainfall.

Desert Plants

Flora adapted to arid environments, often featuring modifications like thick stems or leaves that minimize water loss.