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

Question

​
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

Quizplus · Accepted Answer

The SQL statement that will return the names of all customers who placed an order on April 12,2003 is option B. This is because it uses the NATURAL JOIN clause to join the ORDERS table with the CUSTOMERS table. This will return all customers who have placed an order on April 12, 2003, without the need to specify customer numbers or any other condition explicitly. Option A would only work if there was a column called "orderdate" in the CUSTOMERS table, which is not provided in the table structure. Option C has a syntax error, as it is missing the column name after the "ON" keyword. Option D is not correct because option A is incorrect.

​ Structure of the ORDERS Table

Structure of the ORDERS Table