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.
Answer: See the explanation.
Explanation:
SELECT SalesTerritoryID,
ProductID,AVG(UnitPrice),
MAX(OrderQty),
MAX(DiscountAmount)
FROM Sales.Details
GROUP BY SalesTerritoryID , ProductID
ORDER BY SalesTerritoryID DESC, ProductID DESC
SELECT SalesTerritoryID,
ProductID,
AVG(UnitPrice) AS AVG_UnitPrice,
MAX(OrderQty) AS MAX_OrderQty,
MAX(DiscountAmount) AS MAX_DiscountAmount
FROM Sales.Details
GROUP BY SalesTerritoryID, ProductID
ORDER BY SalesTerritoryID DESC, ProductID DESC;
SELECT SalesTerritoryID,
ProductID,
AVG(UnitPrice),
MAX(OrderQty),
MAX(DiscountAmount)
FROM Sales.Details
GROUP BY SalesTerritoryID, ProductID
ORDER BY SalesTerritoryID DESC, ProductID DESC
The question doesn’t say anything about aliasing…