​ Structure of the ORDERS Table

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 customers NATURAL JOIN orders
WHERE orders.customer# IS NOT NULL;
B) SELECT lastname,firstname,order#
FROM customers,orders
WHERE orders.customer# (+) = customers.customer#;
C) SELECT lastname,firstname,order#
FROM customers,orders
WHERE orders.customer# = customers.customer# (+) ;
D) SELECT lastname,firstname,order#
FROM customers NATURAL JOIN orders
WHERE orders.customer# IS NULL;