3 lines
359 B
SQL
3 lines
359 B
SQL
SELECT SUM(OrderQty), ProductID FROM AdventureWorks.Sales.SalesOrderDetail GROUP BY ProductID;
|
|
SELECT SUM(OrderQty), ProductID FROM AdventureWorks.Sales.SalesOrderDetail GROUP BY ProductID ORDER BY SUM(OrderQty);
|
|
SELECT SUM(OrderQty), ProductID FROM AdventureWorks.Sales.SalesOrderDetail GROUP BY ProductID HAVING SUM(OrderQty) >= 2000 ORDER BY SUM(OrderQty); |