SELECT TOP 10 SOD.ProductID, SUM(SOD.OrderQty)
FROM Sales.SalesOrderDetail AS SOD
GROUP BY SOD.ProductID
ORDER BY SUM(SOD.OrderQty) DESC