You need to create a query that calculates the total sales of each OrderlD from a table named
Sales.Details. The table contains two columns named OrderlD and ExtendedAmount. The solution
must meet the following requirements.
– Use one-part names to reference columns.
– Start the order of the results from OrderlD.
– NOT depend on the default schema of a user.
– Use an alias of TotalSales for the calculated ExtendedAmount.
– Display only the OrderlD column and the calculated TotalSales column.
Provide the correct code in the answer area. Key Words:

Answer: See the explanation

Explanation:
SELECT OrderID,
SUM(ExtendedAmount) AS TotalSales
FROM Sales.Details
GROUP BY OrderID

ORDER BY OrderID