You need to create a query that calculates the total sales of each OrderID from a table named Sales.Details. The table contains two columns named OrderID and ExtendedAmount.
The solution must meet the following requirements:
✑ Use one-part names to reference columns.
✑ Order the results by OrderID with the smallest value first.
✑ NOT depend on the default schema of a user.
✑ Use an alias of TotalSales for the calculated ExtendedAmount.
✑ Display only the OrderID column and the calculated TotalSales column.
Provide the correct code in the answer area.
Key Words:
Answer:
SELECT OrderId, SUM(ExtendedAmount) AS TotalSales FROM Sales.Details ORDER BY OrderID ASC
No comments:
Post a Comment