2 lines
301 B
SQL
2 lines
301 B
SQL
SELECT ProductID, SUM(LineTotal) FROM AdventureWorks.Sales.SalesOrderDetail WHERE UnitPrice < 5.00 GROUP BY ProductID ORDER BY ProductID;
|
|
SELECT ProductID, OrderQty, SUM(LineTotal) FROM AdventureWorks.Sales.SalesOrderDetail WHERE UnitPrice < 5.00 GROUP BY CUBE(ProductID, OrderQty) ORDER BY ProductID; |