Câu 20: 70-461: MCSA Querying Microsoft SQL Server 2012/2014

SIMULATION -You have a database named Sales that contains the tables sworn in the exhibit. (Click the Exhibit button.) You need to create a query for a report. The query must meet the following requirements: ✑ Return the last name of the customer who placed the order. ✑ Return the most recent order date for each customer. ✑ Group the results by CustomerI D. ✑ Display the most recent OrderDate first. The solution must support the ANSI SQL-99 standard and must not use table or column aliases. Part of the correct Transact-SQL has been provided in the answer area below. Enter the Transact-SQL in the answer area that resolves the problem and meets the stated goals or requirements. You can add Transact-SQL within the Transact-SQL segment that has been provided as well as below it.

1. A. Please review the explanation part for this answer. 1. SELECT LastName,2 MAX(OrderDate) AS MostRecentOrderDate3 FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID4 GROUP BY CustomerID5 ORDER BY OrderDate DESCOn line 3 add Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerIDOn line 4 add CustomerID -On line 5 add OrderDate DESC -References:https://technet.microsoft.com/en-us/library/ms190014(v=sql.105).aspx — đáp án hiện tại