Which code segment should you use?

CORRECT TEXT

You have a database that contains the tables shown in the exhibit. (Click the Exhibit button).

You need to create a query for a report.

The query must meet the following requirements:

• NOT use object delimiters.

• Return the most recent orders first.

• Use the first initial of the table as an alias.

• Return the most recent order date for each customer.

• Retrieve the last name of the person who placed the order.

• Return the order date in a column named MostRecentOrderDate that appears as the last column in the report.

The solution must support the ANSI SQL-99 standard.

Which code segment should you use? To answer, type the correct code in the answer area.

View Answer

Answer: