Arithmetic DIVIDE operator

SQL Server Query

            
SELECT TOP 25  

    od.OrderID,  

    od.ProductID,  

    od.UnitPrice,  

    (od.Quantity * od.UnitPrice) AS ProductSales,  

    SUM(od.Quantity * od.UnitPrice) OVER (PARTITION BY od.OrderID) AS TotalOrderSales,  

    od.UnitPrice / SUM(od.Quantity * od.UnitPrice) OVER (PARTITION BY od.OrderID) AS UnitPriceAsFractionOfOrder  

FROM [Order Details] AS od  

ORDER BY od.OrderID, od.ProductID;  

            
        

Create SQL query with SqlQueryBuilder

            
var (sql, parameters) = new SqlQueryBuilder()  

    .Select().Top(25)  

    .Columns("od.OrderID", "od.ProductID", "od.UnitPrice")  

    .Column(new ColumnArithmatic("od.Quantity").MULTIPLY("od.UnitPrice"), "ProductSales")  

    .Column(new SUM(new ColumnArithmatic("od.Quantity").MULTIPLY("od.UnitPrice"))  

        .OVER(new OVER().PARTITION_BY(new Column("od.OrderID"))), "TotalOrderSales")  

    .Column(new ColumnArithmatic("od.UnitPrice").DIVIDE(  

            new SUM(new ColumnArithmatic("od.Quantity").MULTIPLY("od.UnitPrice"))  

                .OVER(new OVER().PARTITION_BY(new Column("od.OrderID")))  

        ), "UnitPriceAsFractionOfOrder")  

    .From("[Order Details]", "od")  

    .OrderBy(new OrderBy()  

        .SetColumnAscending("od.OrderID")  

        .SetColumnAscending("od.ProductID"))  

    .Build();  

            
        

Query build by SqlQueryBuilder

            
SELECT TOP 25 od.OrderID,
              od.ProductID,
              od.UnitPrice,
              od.Quantity * od.UnitPrice AS ProductSales,
              SUM(od.Quantity * od.UnitPrice) OVER (PARTITION BY od.OrderID) AS TotalOrderSales,
              od.UnitPrice / SUM(od.Quantity * od.UnitPrice) OVER (PARTITION BY od.OrderID) AS UnitPriceAsFractionOfOrder
FROM [Order Details] AS od
ORDER BY od.OrderID ASC, od.ProductID ASC;


            
        

Parameters (If used)

Query Results: