SQL query that returns a list of all the products sold with a running total for each product and each day plus a total for each day and product using Windows over function

dayproducttotal-window.sql

SET NOCOUNT ON;
 
SELECT
    ProductID
    ,ModifiedDate
    ,UnitPrice
    ,SUM(UnitPrice) OVER (
        PARTITION BY ModifiedDate
        ORDER BY ProductID, ModifiedDate, SalesOrderID
        ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) ASModifiedDateBalance
    ,SUM(UnitPrice) OVER (
        PARTITION BY ProductID
        ORDER BY ProductID, ModifiedDate, SalesOrderID
        ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) ASProductIdBalance
    ,SUM(UnitPrice) OVER (
        PARTITION BY ModifiedDate, ProductID) AS ModifiedDateTotal
    ,SUM(UnitPrice) OVER (
        PARTITION BY ProductID) AS ProductIdTotal
FROM
 
Sales.SalesOrderDetail
 
ORDER BY ProductID, ModifiedDate, SalesOrderID;