​ 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