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.

View Answer

Answer: