Question

Which SQL statement retrieves last names and first names of customers who placed orders on '12-APR-03'?

A. SELECT lastname, firstname FROM customers NATURAL JOIN orders WHERE orderdate = '12-APR-03';
B. SELECT lastname, firstname, order# FROM customers c LEFT OUTER JOIN orders o ON c.customer# = o.customer#;
C. SELECT lastname, firstname, order# FROM customers, orders WHERE orders.customer# (+) = customers.customer#;
D. SELECT lastname, firstname FROM customers c, books b, orders o, orderitems oi WHERE c.customer# = o.customer# AND # = # AND = AND title LIKE '%BUSI%';

Answer 1

The correct SQL statement to retrieve the last names and first names of customers who placed orders on '12-APR-03' is option A, using a NATURAL JOIN between 'customers' and 'orders' tables and a WHERE clause to filter by the desired order date.

Step-by-step explanation:

To retrieve the last names and first names of customers who placed orders on '12-APR-03', we must look at the SQL statements and determine which one correctly joins the 'customers' and 'orders' tables and filters the data by the specified order date.

Option A: SELECT lastname, firstname FROM customers NATURAL JOIN orders WHERE orderdate = '12-APR-03'; This is the correct SQL statement because it natural joins the 'customers' and 'orders' tables, which means it will automatically join them using the common columns between the two tables, and filters the orders by the specified date.

Option B is not correct because it does not include the WHERE clause to filter the orders by the specified date, and similarly, options C and D are incorrect because they either do not filter by date or involve additional unnecessary tables or incorrect syntax.