'SQL QUERY for showing top 10 products by unit volume, AdventureWorks database

I am currently using the AdventureWorks database and trying to show top 10 products by unit volume. I would like it to look like my top 10 sales summary. Any thoughts on a quick edit to just have it show top 10 products by unit volume for the same 2013 year?

This is what I used for top 10 sales.

SELECT TOP 10
     sod.ProductID
    ,prd.Name
    ,SUM(LineTotal) AS SumOfSales
FROM Sales.SalesOrderDetail AS SOD
JOIN Sales.SalesOrderHeader AS SOH
    ON SOD.SalesOrderID = SOH.SalesOrderID
JOIN Production.Product prd
    ON prd.ProductID  = sod.ProductID
WHERE SOH.OrderDate > '01/01/2013' AND SOH.OrderDate < '12/31/2013'
GROUP BY sod.ProductID, prd.Name
--HAVING SUM(LineTotal) >= 2000000
ORDER BY SUM(LineTotal) DESC
sqlsql-serveradventureworks


Solution 1:[1]

SELECT TOP 10
 sod.ProductID
,prd.Name
,SUM(OrderQty) AS SumOfSales
FROM Sales.SalesOrderDetail AS SOD
JOIN Sales.SalesOrderHeader AS SOH
ON SOD.SalesOrderID = SOH.SalesOrderID
JOIN Production.Product prd 
ON prd.ProductID  = sod.ProductID
WHERE SOH.OrderDate > '01/01/2013' AND SOH.OrderDate < '12/31/2013'
GROUP BY sod.ProductID, prd.Name

ORDER BY SUM(OrderQty) DESC

This is what I came up with I just switched LineTotal and Order QTY

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Brandon

Related Questions