SELECT ProductID, SUM$($Qty$)$ AS TotalQty

FROM FactTable

WHERE DepartmentID $=($SELECT DepartmentID FROM Department WHERE DepartmentName $=$ 'Beauty&Health'$)$

AND MONTH$($TransactionTime$)$ BETWEEN $10$ AND $12$

GROUP BY ProductID

ORDER BY TotalQty DESC;