​ Structure of the ORDERS Table

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