Queries for Order Details

1. Order Details where the Quantity is between 10 and 20 (inclusive) AND the Discount is 0, OR the UnitPrice is greater than 100 AND the Discount is greater than 0, AND the order was placed in 1998.

SQL Server Query 1

            
 SELECT  

     od.OrderID,  

     od.ProductID,  

     od.Quantity,  

     od.UnitPrice,  

     od.Discount,  

     o.OrderDate  

 FROM [Order Details] od  

 JOIN Orders o ON od.OrderID = o.OrderID  

 WHERE  

     (  

         (od.Quantity BETWEEN 10 AND 20 AND od.Discount = 0)  

         OR  

         (od.UnitPrice > 100 AND od.Discount > 0)  

     )  

     AND YEAR(o.OrderDate) = 1998;  

            
        

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .Select()  

     .Columns("od.OrderID", "od.ProductID", "od.Quantity", "od.UnitPrice", "od.Discount", " o.OrderDate")  

     .From("[Order Details]")  

     .Join(new List<IJoin>()   

     {  

         new INNERJOIN().TableName("Orders", "o")  

             .On(new Column("od.OrderID").Equale(new Column("o.OrderID")))  

     })  

     .Where(  

         new Where().StartBracket().StartBracket(new BETWEEN(new Column("od.Quantity"), 10, 20)).AND(new Column("od.Discount").Equale(0)).EndBracket()  

             .OR().StartBracket(new Column("od.UnitPrice").GreaterThan(100)).AND(new Column("od.Discount").GreaterThan(0)).EndBracket()  

             .EndBracket().AND(new YEAR(new Column("o.OrderDate").Equale(100)))  

     )  

     .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT od.OrderID,
       od.ProductID,
       od.Quantity,
       od.UnitPrice,
       od.Discount,
       o.OrderDate
FROM [Order Details] AS od
     INNER JOIN
     Orders AS o
     ON od.OrderID = o.OrderID
WHERE ((od.Quantity BETWEEN @pMAIN_2507192053203523090 AND @pMAIN_2507192053203523091
        AND od.Discount = @pMAIN_2507192053203523092)
       OR (od.UnitPrice > @pMAIN_2507192053203523093
           AND od.Discount > @pMAIN_2507192053203523094))
      AND YEAR(o.OrderDate) = @pMAIN_2507192053203523095;


            
        

Parameters (If used)

Query Results 1: