You have a database that contains the tables shown in the exhibit. 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.
Answer: See the explanation
Explanation:
SELECT C.LastName, MAX(O.OrderDate) AS MostRecentOrderDate
FROM Customers AS C INNER JOIN Orders AS O
ON C.CustomerID = O.CustomerID
GROUP BY C.LastName
ORDER BY O.OrderDate DESC
Answer should be:
SELECT C.LastName, MAX(O.OrderDate) AS MostRecentOrderDate
FROM Customers AS C INNER JOIN Orders AS O
ON C.CustomerID = O.CustomerID
GROUP BY C.LastName, C.CustomerID
ORDER BY MostRecentOrderDate DESC
You need to group by both c.CustomerID and c.LastName because if not you could have duplicate last names
0
0