Câu 9: 70-761: Querying Data with Transact-SQL

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section. You will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a database that includes the tables shown in the exhibit (Click the Exhibit button.) You need to create a Transact-SQL query that returns the following information: ✑ the customer number ✑ the customer contact name ✑ the date the order was placed, with a name of DateofOrder ✑ a column named Salesperson, formatted with the employee first name, a space, and the employee last name ✑ orders for customers where the employee identifier equals 4The output must be sorted by order date, with the newest orders first. The solution must return only the most recent order for each customer.Solution: You run the following Transact-SQL statement: Does the solution meet the goal?

1. A. Yes
2. B. No — đáp án hiện tại