Arithmetic MULTIPLY operator

SQL Server Query

            
SELECT  

    OrderID,  

    SUM(UnitPrice * Quantity * (1 - Discount)) AS TotalOrderCost  

FROM [Order Details]  

GROUP BY OrderID;  

            
        

Create SQL query with SqlQueryBuilder

            
var (sql, parameters) = new SqlQueryBuilder()  

    .Select()  

    .Columns("OrderID")  

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

        .StartBracket(1).SUBTRACT("Discount").EndBracket())  

    , "TotalOrderCost")  

    .From("[Order Details]")  

    .GroupBy(new GroupBy("OrderID")) 

    .Build();  

            
        

Query build by SqlQueryBuilder

            
SELECT OrderID,
       SUM(UnitPrice * Quantity * (@pMAIN_2507200130333089830 - Discount)) AS TotalOrderCost
FROM [Order Details]
GROUP BY OrderID;


            
        

Parameters (If used)

Query Results: