CORRECT TEXT
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:
Select OrderID, Sum(ExtendedAmount) AS TotalSales
From Sales.Details
Group BY OrderID
Order By OrderID ASC;