AVG SQL function

1. Usage of AVG along to find product price difference

SQL Server Query 1

            
SELECT  

    ProductID,  

    ProductName,  

    UnitPrice,  

    (SELECT AVG(UnitPrice) FROM Products) AS AveragePrice,  

    ABS(UnitPrice - (SELECT AVG(UnitPrice) FROM Products)) AS PriceDifference  

FROM Products;  

            
        

Create SQL query with SqlQueryBuilder 1

            
var (sql2, parameters2) = new SqlQueryBuilder()  

    .Select()  

    .Columns("ProductID", "ProductName", "UnitPrice")  

    .Column(new SqlQueryBuilder().Select().Column(new AVG(new Column("UnitPrice")), "AveragePrice").From("Products"), "AveragePrice")  

    .Column(new ABS(  

        new ColumnArithmatic().Column("UnitPrice").SUBTRACT().Column(  

            new SqlQueryBuilder().Select().Column(new AVG(new Column("UnitPrice")), "PriceDifference").From("Products")  

        )), "PriceDifference")  

    .From("Products")  

    .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT ProductID,
       ProductName,
       UnitPrice,
       (SELECT AVG(UnitPrice) AS AveragePrice
        FROM Products) AS AveragePrice,
       ABS(UnitPrice - (SELECT AVG(UnitPrice) AS PriceDifference
                        FROM Products)) AS PriceDifference
FROM Products;


            
        

Parameters (If used)

Query Results 1: