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 customers NATURAL JOIN orders;
B) SELECT lastname, firstname, order# FROM customers c LEFT OUTER JOIN orders o ON
C) SELECT lastname, firstname, order# FROM customers RIGHT OUTER JOIN orders;
D)customer# = o.customer#;
E) SELECT lastname, firstname, order# FROM customers JOIN orders USING (customer#);

Question

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 customers NATURAL JOIN orders; 
B) SELECT lastname, firstname, order# FROM customers c LEFT OUTER JOIN orders o ON 
C) SELECT lastname, firstname, order# FROM customers RIGHT OUTER JOIN orders; 
D)customer# = o.customer#; 
E) SELECT lastname, firstname, order# FROM customers JOIN orders USING (customer#);

Quizplus · Accepted Answer

This query uses a LEFT OUTER JOIN to ensure that all customers are included in the result, even if they have not placed an order. The JOIN condition is based on the customer# field, which is present in both the CUSTOMERS and ORDERS tables. The SELECT clause includes the lastname and firstname fields from the CUSTOMERS table and the order# field from the ORDERS table. If a customer has not placed an order, the order# field will contain NULL in the result.

Structure of the ORDERS Table