Total Units Sold Per Product
Total Units Sold Per Product
OrderDetails Table:
Query Explanation:
-
SUM(od.Quantity): Adds up all quantities sold for each product. -
JOIN Products: To get the product name (for clarity). -
GROUP BY p.ProductID, p.ProductName: Groups results by each product. -
ORDER BY TotalUnitsSold DESC: Sorts from most sold to least.
SQL Query:
SELECT
p.ProductID,
p.ProductName,
SUM(od.Quantity) AS TotalUnitsSold
FROM
OrderDetails od
JOIN
Products p ON od.ProductID = p.ProductID
GROUP BY
p.ProductID, p.ProductName
ORDER BY
TotalUnitsSold DESC;
Output:
