SELECT
SalesOrderDetailID,
SUM(LineTotal) OVER (PARTITION BY SalesOrderID)
AS [Total],
COUNT(*) OVER (PARTITION BY ProductID)
AS [Prod Count]
FROM Sales.SalesOrderDetail
a
b
c
