Which code segment should you use?

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

You have the following query:

You need to recreate the query to meet the following requirements:
• Reference columns by using one-part names only.
• Sort aggregates by SalesTerritoryID, and then by ProductID.
• Order the results in descending order from SalesTerritoryID to ProductID.
• The solution must use the existing SELECT clause and FROM clause.
Which code segment should you use?
To answer, type the correct code in the answer area.
A. Please review the part for this answer

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.