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.
Answer: See the explanation
Explanation:
SELECT OrderID, SUM(ExtendedAmount) AS TotalSales FROM Sales.Details GROUP BY OrderID ORDER BY OrderID
Correct
4
0
correct
1
0
Why there is an order by?
because of this:
“Start the order of the results from OrderlD”
couldn’t this mean that OrderID must be the first column, and not defining the results in ascending or descending order?
if this true, this solution would be right, but a solution without the order by would be also correct
4
0