SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE sales (
    productId INT,
    date DATE,
    price NUMERIC(19,2)
)

INSERT INTO sales
VALUES
    (1, '2025-02-01', 10.0),
    (1, '2025-02-02', 20.0), -- two sales same date
    (1, '2025-02-02', 30.0), -- two sales same date
    (1, '2025-02-03', 40.0)

select * from sales


productId
date
price


1
2025-02-01
10.00

1
2025-02-02
20.00

1
2025-02-02
30.00

1
2025-02-03
40.00


set statistics xml on
-- Inline window over() clauses
-- Results are as expected
with calendar as (
    select min(date) as date, max(date) as endDate
    from sales
    union all
    select dateadd(day, 1, date), endDate
    from calendar
    where date < enddate
),
products as (
    select distinct productid
    from sales
)
select
    p.productid,
    c.date as salesDate, 
    avg(price) as avg1DayPrice,
    sum(sum(s.price)) over (partition by p.productid
                            order by c.date
                            rows between 6 preceding and current row)
        / nullif(
             sum(count(s.price)) over(partition by p.productid
                                      order by c.date
                                      rows between 6 preceding and current row),
             0)
        as avg7DayPrice
from calendar c
cross join products p
left join sales s
    on s.date = c.date
    and s.productid = p.productid
group by p.productid, c.date


productid
salesDate
avg1DayPrice
avg7DayPrice


1
2025-02-01
10.000000
10.000000

1
2025-02-02
25.000000
20.000000

1
2025-02-03
40.000000
25.000000




Microsoft SQL Server 2005 XML Showplan


<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.564" Build="16.0.1000.6"><BatchSequence><Batch><Statements><StmtSimple StatementText="with calendar as (&#xa;    select min(date) as date, max(date) as endDate&#xa;    from sales&#xa;    union all&#xa;    select dateadd(day, 1, date), endDate&#xa;    from calendar&#xa;    where date &lt; enddate&#xa;),&#xa;products as (&#xa;    select distinct productid&#xa;    from sales&#xa;)&#xa;select&#xa;    p.productid,&#xa;    c.date as salesDate, &#xa;    avg(price) as avg1DayPrice,&#xa;    sum(sum(s.price)) over (partition by p.productid&#xa;                            order by c.date&#xa;                            rows between 6 preceding and current row)&#xa;        / nullif(&#xa;             sum(count(s.price)) over(partition by p.productid&#xa;                                      order by c.date&#xa;                                      rows between 6 preceding and current row),&#xa;             0)&#xa;        as avg7DayPrice&#xa;from calendar c&#xa;cross join products p&#xa;left join sales s&#xa;    on s.date = c.date&#xa;    and s.productid = p.productid&#xa;group by p.productid, c.date" StatementId="1" StatementCompId="1" StatementType="SELECT" StatementSqlHandle="0x0900A6F93178CEEB13D921B7359DC96F5A940000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="0" StatementParameterizationType="0" RetrievedFromCache="true" StatementSubTreeCost="0.0673492" StatementEstRows="2" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xD0E807F166252861" QueryPlanHash="0xFC2A55566A2FDBD1" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="160"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="0" MemoryGrant="1088" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="152" CompileTime="15" CompileCPU="0" CompileMemory="928"><MemoryGrantInfo SerialRequiredMemory="1024" SerialDesiredMemory="1088" RequiredMemory="1024" DesiredMemory="1088" RequestedMemory="1088" GrantWaitTime="0" MaxQueryMemory="851104" GrantedMemory="1088" MaxUsedMemory="24"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="2572184"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2025-02-06T19:17:47.28" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000001_35BCFE0A]" Table="[sales]" Schema="[dbo]" Database="[fiddle_a20b6110517f40fda77f09099ce56244]"></StatisticsInfo><StatisticsInfo LastUpdate="2025-02-06T19:17:47.28" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000002_35BCFE0A]" Table="[sales]" Schema="[dbo]" Database="[fiddle_a20b6110517f40fda77f09099ce56244]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2" EstimateIO="0" EstimateCPU="2e-07" AvgRowSize="48" EstimatedTotalSubtreeCost="0.0673492" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1021"></ColumnReference><ScalarOperator ScalarString="[Expr1018]/CONVERT_IMPLICIT(numeric(10,0),CASE WHEN [Expr1019]=(0) THEN NULL ELSE [Expr1020] END,0)"><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Expr1018"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="numeric" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1019"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1020"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="1" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2" EstimateIO="0" EstimateCPU="2e-07" AvgRowSize="56" EstimatedTotalSubtreeCost="0.067349" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1018"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1026]=(0) THEN NULL ELSE [Expr1027] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1026"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1027"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1019"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1028]=(0) THEN NULL ELSE [Expr1029] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1028"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1029"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1020"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1030]=(0) THEN NULL ELSE [Expr1031] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1030"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1031"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2" EstimateIO="0" EstimateCPU="2e-07" AvgRowSize="81" EstimatedTotalSubtreeCost="0.0673488" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference><ColumnReference Column="Expr1029"></ColumnReference><ColumnReference Column="Expr1030"></ColumnReference><ColumnReference Column="Expr1031"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1026"></ColumnReference><ScalarOperator ScalarString="[CumulativeBottom1032]-[CumulativeTop1033]"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="CumulativeBottom1032"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="CumulativeTop1033"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1027"></ColumnReference><ScalarOperator ScalarString="[CumulativeBottom1034]-[CumulativeTop1035]"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="CumulativeBottom1034"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="CumulativeTop1035"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1028"></ColumnReference><ScalarOperator ScalarString="[CumulativeBottom1036]-[CumulativeTop1037]"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="CumulativeBottom1036"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="CumulativeTop1037"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1029"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[CumulativeBottom1038]-[CumulativeTop1039],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="CumulativeBottom1038"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="CumulativeTop1039"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1030"></ColumnReference><ScalarOperator ScalarString="[CumulativeBottom1040]-[CumulativeTop1041]"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="CumulativeBottom1040"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="CumulativeTop1041"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1031"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[CumulativeBottom1042]-[CumulativeTop1043],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="CumulativeBottom1042"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="CumulativeTop1043"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="3" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2" EstimateIO="0" EstimateCPU="0" AvgRowSize="134" EstimatedTotalSubtreeCost="0.0673486" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="CumulativeBottom1032"></ColumnReference><ColumnReference Column="CumulativeTop1033"></ColumnReference><ColumnReference Column="CumulativeBottom1034"></ColumnReference><ColumnReference Column="CumulativeTop1035"></ColumnReference><ColumnReference Column="CumulativeBottom1036"></ColumnReference><ColumnReference Column="CumulativeTop1037"></ColumnReference><ColumnReference Column="CumulativeBottom1038"></ColumnReference><ColumnReference Column="CumulativeTop1039"></ColumnReference><ColumnReference Column="CumulativeBottom1040"></ColumnReference><ColumnReference Column="CumulativeTop1041"></ColumnReference><ColumnReference Column="CumulativeBottom1042"></ColumnReference><ColumnReference Column="CumulativeTop1043"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="CumulativeTop1041"></ColumnReference><ScalarOperator ScalarString="[CumulativeTop1037]"><Identifier><ColumnReference Column="CumulativeTop1037"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="CumulativeTop1043"></ColumnReference><ScalarOperator ScalarString="[CumulativeTop1039]"><Identifier><ColumnReference Column="CumulativeTop1039"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="4" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="1.256e-06" AvgRowSize="134" EstimatedTotalSubtreeCost="0.0673486" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="CumulativeBottom1032"></ColumnReference><ColumnReference Column="CumulativeTop1033"></ColumnReference><ColumnReference Column="CumulativeBottom1034"></ColumnReference><ColumnReference Column="CumulativeTop1035"></ColumnReference><ColumnReference Column="CumulativeBottom1036"></ColumnReference><ColumnReference Column="CumulativeTop1037"></ColumnReference><ColumnReference Column="CumulativeBottom1038"></ColumnReference><ColumnReference Column="CumulativeTop1039"></ColumnReference><ColumnReference Column="CumulativeBottom1040"></ColumnReference><ColumnReference Column="CumulativeBottom1042"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="CumulativeTop1033"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1016])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1016"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="CumulativeTop1035"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1016])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1016"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="CumulativeTop1037"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1017])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1017"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="CumulativeTop1039"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1017])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1017"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Recr1008"></ColumnReference><ScalarOperator ScalarString="ANY([Recr1008])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Recr1008"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1015"></ColumnReference><ScalarOperator ScalarString="ANY([Expr1015])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1015"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="CumulativeBottom1032"></ColumnReference><ScalarOperator ScalarString="ANY([CumulativeBottom1032])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="CumulativeBottom1032"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="CumulativeBottom1034"></ColumnReference><ScalarOperator ScalarString="ANY([CumulativeBottom1034])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="CumulativeBottom1034"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="CumulativeBottom1036"></ColumnReference><ScalarOperator ScalarString="ANY([CumulativeBottom1036])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="CumulativeBottom1036"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="CumulativeBottom1038"></ColumnReference><ScalarOperator ScalarString="ANY([CumulativeBottom1038])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="CumulativeBottom1038"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="CumulativeBottom1040"></ColumnReference><ScalarOperator ScalarString="ANY([CumulativeBottom1040])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="CumulativeBottom1040"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="CumulativeBottom1042"></ColumnReference><ScalarOperator ScalarString="ANY([CumulativeBottom1042])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="CumulativeBottom1042"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Column="WindowCount1060"></ColumnReference></GroupBy><RelOp NodeId="5" PhysicalOp="Window Spool" LogicalOp="Window Spool" EstimateRows="4" EstimateIO="0" EstimateCPU="4.396e-06" AvgRowSize="134" EstimatedTotalSubtreeCost="0.0673474" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="CumulativeBottom1032"></ColumnReference><ColumnReference Column="CumulativeBottom1034"></ColumnReference><ColumnReference Column="CumulativeBottom1036"></ColumnReference><ColumnReference Column="CumulativeBottom1038"></ColumnReference><ColumnReference Column="CumulativeBottom1040"></ColumnReference><ColumnReference Column="CumulativeBottom1042"></ColumnReference><ColumnReference Column="RowNumber1045"></ColumnReference><ColumnReference Column="WindowCount1060"></ColumnReference><ColumnReference Column="Segment1059"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><WindowSpool><RelOp NodeId="6" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="2" EstimateIO="0" EstimateCPU="1.256e-07" AvgRowSize="134" EstimatedTotalSubtreeCost="0.0673425" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="CumulativeBottom1032"></ColumnReference><ColumnReference Column="CumulativeBottom1034"></ColumnReference><ColumnReference Column="CumulativeBottom1036"></ColumnReference><ColumnReference Column="CumulativeBottom1038"></ColumnReference><ColumnReference Column="CumulativeBottom1040"></ColumnReference><ColumnReference Column="CumulativeBottom1042"></ColumnReference><ColumnReference Column="RowNumber1045"></ColumnReference><ColumnReference Column="BottomRowNumber1046"></ColumnReference><ColumnReference Column="Segment1059"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1059"></ColumnReference></SegmentColumn><RelOp NodeId="7" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2" EstimateIO="0" EstimateCPU="2e-07" AvgRowSize="126" EstimatedTotalSubtreeCost="0.0673424" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="CumulativeBottom1032"></ColumnReference><ColumnReference Column="CumulativeBottom1034"></ColumnReference><ColumnReference Column="CumulativeBottom1036"></ColumnReference><ColumnReference Column="CumulativeBottom1038"></ColumnReference><ColumnReference Column="CumulativeBottom1040"></ColumnReference><ColumnReference Column="CumulativeBottom1042"></ColumnReference><ColumnReference Column="RowNumber1045"></ColumnReference><ColumnReference Column="BottomRowNumber1046"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="BottomRowNumber1046"></ColumnReference><ScalarOperator ScalarString="[RowNumber1045]-(7)"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="RowNumber1045"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(7)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="8" PhysicalOp="Sequence Project" LogicalOp="Compute Scalar" EstimateRows="2" EstimateIO="0" EstimateCPU="1.6e-07" AvgRowSize="118" EstimatedTotalSubtreeCost="0.0673422" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="CumulativeBottom1032"></ColumnReference><ColumnReference Column="CumulativeBottom1034"></ColumnReference><ColumnReference Column="CumulativeBottom1036"></ColumnReference><ColumnReference Column="CumulativeBottom1038"></ColumnReference><ColumnReference Column="CumulativeBottom1040"></ColumnReference><ColumnReference Column="CumulativeBottom1042"></ColumnReference><ColumnReference Column="RowNumber1045"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><SequenceProject><DefinedValues><DefinedValue><ColumnReference Column="RowNumber1045"></ColumnReference><ScalarOperator ScalarString="row_number"><Sequence FunctionName="row_number"></Sequence></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="9" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="2" EstimateIO="0" EstimateCPU="4e-08" AvgRowSize="118" EstimatedTotalSubtreeCost="0.067342" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="CumulativeBottom1032"></ColumnReference><ColumnReference Column="CumulativeBottom1034"></ColumnReference><ColumnReference Column="CumulativeBottom1036"></ColumnReference><ColumnReference Column="CumulativeBottom1038"></ColumnReference><ColumnReference Column="CumulativeBottom1040"></ColumnReference><ColumnReference Column="CumulativeBottom1042"></ColumnReference><ColumnReference Column="Segment1058"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1058"></ColumnReference></SegmentColumn><RelOp NodeId="10" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2" EstimateIO="0" EstimateCPU="0" AvgRowSize="68" EstimatedTotalSubtreeCost="0.067342" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="CumulativeBottom1032"></ColumnReference><ColumnReference Column="CumulativeBottom1034"></ColumnReference><ColumnReference Column="CumulativeBottom1036"></ColumnReference><ColumnReference Column="CumulativeBottom1038"></ColumnReference><ColumnReference Column="CumulativeBottom1040"></ColumnReference><ColumnReference Column="CumulativeBottom1042"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="CumulativeBottom1040"></ColumnReference><ScalarOperator ScalarString="[CumulativeBottom1036]"><Identifier><ColumnReference Column="CumulativeBottom1036"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="CumulativeBottom1042"></ColumnReference><ScalarOperator ScalarString="[CumulativeBottom1038]"><Identifier><ColumnReference Column="CumulativeBottom1038"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="11" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="1.256e-06" AvgRowSize="68" EstimatedTotalSubtreeCost="0.067342" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="CumulativeBottom1032"></ColumnReference><ColumnReference Column="CumulativeBottom1034"></ColumnReference><ColumnReference Column="CumulativeBottom1036"></ColumnReference><ColumnReference Column="CumulativeBottom1038"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="CumulativeBottom1032"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1016])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1016"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="CumulativeBottom1034"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1016])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1016"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="CumulativeBottom1036"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1017])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1017"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="CumulativeBottom1038"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1017])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1017"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Recr1008"></ColumnReference><ScalarOperator ScalarString="ANY([Recr1008])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Recr1008"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1015"></ColumnReference><ScalarOperator ScalarString="ANY([Expr1015])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1015"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1016"></ColumnReference><ScalarOperator ScalarString="ANY([Expr1016])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1016"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1017"></ColumnReference><ScalarOperator ScalarString="ANY([Expr1017])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1017"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Column="WindowCount1057"></ColumnReference></GroupBy><RelOp NodeId="12" PhysicalOp="Window Spool" LogicalOp="Window Spool" EstimateRows="4" EstimateIO="0" EstimateCPU="4.396e-06" AvgRowSize="68" EstimatedTotalSubtreeCost="0.0673407" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="RowNumber1047"></ColumnReference><ColumnReference Column="WindowCount1057"></ColumnReference><ColumnReference Column="Segment1056"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><WindowSpool><RelOp NodeId="13" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="2" EstimateIO="0" EstimateCPU="1.256e-07" AvgRowSize="68" EstimatedTotalSubtreeCost="0.0673358" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="RowNumber1047"></ColumnReference><ColumnReference Column="Segment1056"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1056"></ColumnReference></SegmentColumn><RelOp NodeId="14" PhysicalOp="Sequence Project" LogicalOp="Compute Scalar" EstimateRows="2" EstimateIO="0" EstimateCPU="1.6e-07" AvgRowSize="60" EstimatedTotalSubtreeCost="0.0673357" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="RowNumber1047"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><SequenceProject><DefinedValues><DefinedValue><ColumnReference Column="RowNumber1047"></ColumnReference><ScalarOperator ScalarString="row_number"><Sequence FunctionName="row_number"></Sequence></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="15" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="2" EstimateIO="0" EstimateCPU="4e-08" AvgRowSize="60" EstimatedTotalSubtreeCost="0.0673355" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Segment1055"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1055"></ColumnReference></SegmentColumn><RelOp NodeId="16" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2" EstimateIO="0" EstimateCPU="0" AvgRowSize="52" EstimatedTotalSubtreeCost="0.0673355" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1015"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1053]=(0) THEN NULL ELSE [Expr1054]/CONVERT_IMPLICIT(numeric(19,0),[Expr1053],0) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1053"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Expr1054"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="numeric" Precision="19" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1053"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1016"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1053]=(0) THEN NULL ELSE [Expr1054] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1053"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1054"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1017"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1053],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1053"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="17" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="4.2e-06" AvgRowSize="52" EstimatedTotalSubtreeCost="0.0673355" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1053"></ColumnReference><ColumnReference Column="Expr1054"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1053"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([fiddle_a20b6110517f40fda77f09099ce56244].[dbo].[sales].[price] as [s].[price])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Alias="[s]" Column="price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1054"></ColumnReference><ScalarOperator ScalarString="SUM([fiddle_a20b6110517f40fda77f09099ce56244].[dbo].[sales].[price] as [s].[price])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Alias="[s]" Column="price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Recr1008"></ColumnReference></GroupBy><RelOp NodeId="18" PhysicalOp="Nested Loops" LogicalOp="Left Outer Join" EstimateRows="5.33333" EstimateIO="0" EstimateCPU="6.688e-05" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0673313" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Alias="[s]" Column="price"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><Predicate><ScalarOperator ScalarString="[fiddle_a20b6110517f40fda77f09099ce56244].[dbo].[sales].[date] as [s].[date]=[Recr1008] AND [fiddle_a20b6110517f40fda77f09099ce56244].[dbo].[sales].[productId] as [s].[productId]=[fiddle_a20b6110517f40fda77f09099ce56244].[dbo].[sales].[productId]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Alias="[s]" Column="date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Recr1008"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Alias="[s]" Column="productId"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate><RelOp NodeId="19" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="4" EstimateIO="0.0112613" EstimateCPU="0.000112494" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0637181" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference></OutputList><MemoryFractions Input="0.5" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="544" OutputMemoryGrant="192" UsedMemoryGrant="16" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Recr1008"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="20" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="4" EstimateIO="0" EstimateCPU="1.672e-05" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0523444" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><RelOp NodeId="21" PhysicalOp="Index Spool" LogicalOp="Lazy Spool" EstimateRows="4" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="10" EstimatedTotalSubtreeCost="0.00329756" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1052"></ColumnReference><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Column="Recr1009"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="7" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Spool Stack="1"><RelOp NodeId="22" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="4" EstimateIO="0" EstimateCPU="2e-09" AvgRowSize="10" EstimatedTotalSubtreeCost="0.00329597" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1052"></ColumnReference><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Column="Recr1009"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Concat><DefinedValues><DefinedValue><ColumnReference Column="Expr1052"></ColumnReference><ColumnReference Column="Expr1049"></ColumnReference><ColumnReference Column="Expr1051"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Recr1009"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Recr1006"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="23" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="2e-08" AvgRowSize="10" EstimatedTotalSubtreeCost="2e-08" Parallel="0" EstimateRebinds="4" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1049"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1049"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="24" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="2.9e-06" AvgRowSize="13" EstimatedTotalSubtreeCost="0.0032893" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1003"></ColumnReference><ScalarOperator ScalarString="MIN([fiddle_a20b6110517f40fda77f09099ce56244].[dbo].[sales].[date])"><Aggregate Distinct="0" AggType="MIN"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="date"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1004"></ColumnReference><ScalarOperator ScalarString="MAX([fiddle_a20b6110517f40fda77f09099ce56244].[dbo].[sales].[date])"><Aggregate Distinct="0" AggType="MAX"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="date"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="25" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="4" EstimatedRowsRead="4" EstimateIO="0.003125" EstimateCPU="0.0001614" AvgRowSize="10" EstimatedTotalSubtreeCost="0.0032864" TableCardinality="4" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="date"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="1" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="4" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="date"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" TableReferenceId="1" IndexKind="Heap" Storage="RowStore"></Object></TableScan></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp><RelOp NodeId="26" PhysicalOp="Assert" LogicalOp="Assert" EstimateRows="4" EstimateIO="0" EstimateCPU="1.68e-07" AvgRowSize="10" EstimatedTotalSubtreeCost="6.665e-06" Parallel="0" EstimateRebinds="4" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1051"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Recr1006"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Assert StartupExpression="0"><RelOp NodeId="27" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="4" EstimateIO="0" EstimateCPU="1.68e-07" AvgRowSize="10" EstimatedTotalSubtreeCost="6.665e-06" Parallel="0" EstimateRebinds="4" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1051"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Recr1006"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Column="Expr1051"></ColumnReference><ColumnReference Column="Recr1005"></ColumnReference><ColumnReference Column="Recr1006"></ColumnReference></OuterReferences><RelOp NodeId="28" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="2e-08" AvgRowSize="10" EstimatedTotalSubtreeCost="2e-08" Parallel="0" EstimateRebinds="4" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1051"></ColumnReference><ColumnReference Column="Recr1005"></ColumnReference><ColumnReference Column="Recr1006"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1051"></ColumnReference><ScalarOperator ScalarString="[Expr1050]+(1)"><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Column="Expr1050"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="29" PhysicalOp="Table Spool" LogicalOp="Lazy Spool" EstimateRows="1" EstimateIO="0" EstimateCPU="2e-08" AvgRowSize="10" EstimatedTotalSubtreeCost="2e-08" Parallel="0" EstimateRebinds="4" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1050"></ColumnReference><ColumnReference Column="Recr1005"></ColumnReference><ColumnReference Column="Recr1006"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Spool PrimaryNodeId="21" Stack="1"></Spool></RelOp></ComputeScalar></RelOp><RelOp NodeId="30" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="10" EstimatedTotalSubtreeCost="6.477e-06" Parallel="0" EstimateRebinds="3" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1007"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1007"></ColumnReference><ScalarOperator ScalarString="dateadd(day,(1),[Recr1005])"><Intrinsic FunctionName="dateadd"><ScalarOperator><Const ConstValue="(4)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Recr1005"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="31" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1" EstimateIO="0" EstimateCPU="4.8e-07" AvgRowSize="9" EstimatedTotalSubtreeCost="6.077e-06" Parallel="0" EstimateRebinds="3" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualRebinds="3" ActualRewinds="0" ActualEndOfScans="3" ActualExecutions="3" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="1"><RelOp NodeId="32" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-06" AvgRowSize="9" EstimatedTotalSubtreeCost="4.157e-06" Parallel="0" EstimateRebinds="0" EstimateRewinds="3" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="2" ActualExecutions="2" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp><Predicate><ScalarOperator ScalarString="[Recr1005]&lt;[Recr1006]"><Compare CompareOp="LT"><ScalarOperator><Identifier><ColumnReference Column="Recr1005"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Recr1006"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></ComputeScalar></RelOp></NestedLoops></RelOp><Predicate><ScalarOperator ScalarString="CASE WHEN [Expr1051]&gt;(100) THEN (0) ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Column="Expr1051"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(100)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Predicate></Assert></RelOp></Concat></RelOp></Spool></RelOp><RelOp NodeId="33" PhysicalOp="Sort" LogicalOp="Distinct Sort" EstimateRows="1" EstimateIO="0.0112613" EstimateCPU="0.000112491" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0490301" Parallel="0" EstimateRebinds="0" EstimateRewinds="3" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference></OutputList><MemoryFractions Input="0.5" Output="0.5"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="2" ActualEndOfScans="3" ActualExecutions="3" InputMemoryGrant="544" OutputMemoryGrant="160" UsedMemoryGrant="16" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="1"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="34" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="4" EstimatedRowsRead="4" EstimateIO="0.0032035" EstimateCPU="8.29e-05" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0035351" TableCardinality="4" Parallel="0" EstimateRebinds="0" EstimateRewinds="3" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="12" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="3" ActualLogicalReads="3" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="12" ActualEndOfScans="3" ActualExecutions="3" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" TableReferenceId="2" IndexKind="Heap" Storage="RowStore"></Object></TableScan></RelOp></Sort></RelOp></NestedLoops></RelOp></Sort></RelOp><RelOp NodeId="35" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="4" EstimatedRowsRead="4" EstimateIO="0.0032035" EstimateCPU="8.29e-05" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0035351" TableCardinality="4" Parallel="0" EstimateRebinds="0" EstimateRewinds="3" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Alias="[s]" Column="productId"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Alias="[s]" Column="date"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Alias="[s]" Column="price"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="12" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="3" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="12" ActualEndOfScans="3" ActualExecutions="3" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Alias="[s]" Column="productId"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Alias="[s]" Column="date"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Alias="[s]" Column="price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Alias="[s]" IndexKind="Heap" Storage="RowStore"></Object></TableScan></RelOp></NestedLoops></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp></Segment></RelOp></SequenceProject></RelOp></Segment></RelOp></WindowSpool></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp></Segment></RelOp></SequenceProject></RelOp></ComputeScalar></RelOp></Segment></RelOp></WindowSpool></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>


-- Reference to common defined window clause
-- Expect same results, but that is not what I get.
with calendar as (
    select min(date) as date, max(date) as endDate
    from sales
    union all
    select dateadd(day, 1, date), endDate
    from calendar
    where date < enddate
),
products as (
    select distinct productid
    from sales
)
select
    p.productid,
    c.date as salesDate, 
    avg(price) as avg1DayPrice,
    sum(sum(s.price)) over last7days
        / nullif(
             sum(count(s.price)) over last7days,
             0)
        as avg7DayPrice
from calendar c
cross join products p
left join sales s
    on s.date = c.date
    and s.productid = p.productid
group by p.productid, c.date
window last7days as (partition by p.productid
                     order by c.date
                     rows between 6 preceding and current row)


productid
salesDate
avg1DayPrice
avg7DayPrice


1
2025-02-01
10.000000
2.500000

1
2025-02-02
25.000000
15.000000

1
2025-02-03
40.000000
25.000000




Microsoft SQL Server 2005 XML Showplan


<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.564" Build="16.0.1000.6"><BatchSequence><Batch><Statements><StmtSimple StatementText="with calendar as (&#xa;    select min(date) as date, max(date) as endDate&#xa;    from sales&#xa;    union all&#xa;    select dateadd(day, 1, date), endDate&#xa;    from calendar&#xa;    where date &lt; enddate&#xa;),&#xa;products as (&#xa;    select distinct productid&#xa;    from sales&#xa;)&#xa;select&#xa;    p.productid,&#xa;    c.date as salesDate, &#xa;    avg(price) as avg1DayPrice,&#xa;    sum(sum(s.price)) over last7days&#xa;        / nullif(&#xa;             sum(count(s.price)) over last7days,&#xa;             0)&#xa;        as avg7DayPrice&#xa;from calendar c&#xa;cross join products p&#xa;left join sales s&#xa;    on s.date = c.date&#xa;    and s.productid = p.productid&#xa;group by p.productid, c.date&#xa;window last7days as (partition by p.productid&#xa;                     order by c.date&#xa;                     rows between 6 preceding and current row)" StatementId="1" StatementCompId="1" StatementType="SELECT" StatementSqlHandle="0x09000FCDB4A51C81F9A9576B9CA3DF36A63D0000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="0" StatementParameterizationType="0" RetrievedFromCache="true" StatementSubTreeCost="0.0673961" StatementEstRows="2" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x3DD632F6F62560E6" QueryPlanHash="0x3110C9A2D4A6CD40" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="160"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="0" MemoryGrant="1088" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="160" CompileTime="0" CompileCPU="0" CompileMemory="896"><MemoryGrantInfo SerialRequiredMemory="1024" SerialDesiredMemory="1088" RequiredMemory="1024" DesiredMemory="1088" RequestedMemory="1088" GrantWaitTime="0" MaxQueryMemory="851104" GrantedMemory="1088" MaxUsedMemory="24"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="2572184"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2025-02-06T19:17:47.28" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000001_35BCFE0A]" Table="[sales]" Schema="[dbo]" Database="[fiddle_a20b6110517f40fda77f09099ce56244]"></StatisticsInfo><StatisticsInfo LastUpdate="2025-02-06T19:17:47.28" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000002_35BCFE0A]" Table="[sales]" Schema="[dbo]" Database="[fiddle_a20b6110517f40fda77f09099ce56244]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2" EstimateIO="0" EstimateCPU="2e-07" AvgRowSize="48" EstimatedTotalSubtreeCost="0.0673961" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1021"></ColumnReference><ScalarOperator ScalarString="[Expr1018]/CONVERT_IMPLICIT(numeric(10,0),CASE WHEN [Expr1019]=(0) THEN NULL ELSE [Expr1020] END,0)"><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Expr1018"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="numeric" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1019"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1020"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="1" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="2" EstimateIO="0" EstimateCPU="3.60822e-05" AvgRowSize="56" EstimatedTotalSubtreeCost="0.0673959" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><RelOp NodeId="2" PhysicalOp="Table Spool" LogicalOp="Lazy Spool" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="56" EstimatedTotalSubtreeCost="0.0673584" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="7" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Spool><RelOp NodeId="3" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="2" EstimateIO="0" EstimateCPU="4.686e-06" AvgRowSize="56" EstimatedTotalSubtreeCost="0.0673537" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Segment1055"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy></GroupBy><SegmentColumn><ColumnReference Column="Segment1055"></ColumnReference></SegmentColumn><RelOp NodeId="4" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2" EstimateIO="0" EstimateCPU="2e-07" AvgRowSize="56" EstimatedTotalSubtreeCost="0.067349" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1018"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1026]=(0) THEN NULL ELSE [Expr1027] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1026"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1027"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1019"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1028]=(0) THEN NULL ELSE [Expr1029] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1028"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1029"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="5" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2" EstimateIO="0" EstimateCPU="2e-07" AvgRowSize="72" EstimatedTotalSubtreeCost="0.0673488" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference><ColumnReference Column="Expr1029"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1026"></ColumnReference><ScalarOperator ScalarString="[CumulativeBottom1030]-[CumulativeTop1031]"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="CumulativeBottom1030"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="CumulativeTop1031"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1027"></ColumnReference><ScalarOperator ScalarString="[CumulativeBottom1032]-[CumulativeTop1033]"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="CumulativeBottom1032"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="CumulativeTop1033"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1028"></ColumnReference><ScalarOperator ScalarString="[CumulativeBottom1034]-[CumulativeTop1035]"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="CumulativeBottom1034"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="CumulativeTop1035"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1029"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[CumulativeBottom1036]-[CumulativeTop1037],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="CumulativeBottom1036"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="CumulativeTop1037"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="6" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="1.256e-06" AvgRowSize="118" EstimatedTotalSubtreeCost="0.0673486" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="CumulativeBottom1030"></ColumnReference><ColumnReference Column="CumulativeTop1031"></ColumnReference><ColumnReference Column="CumulativeBottom1032"></ColumnReference><ColumnReference Column="CumulativeTop1033"></ColumnReference><ColumnReference Column="CumulativeBottom1034"></ColumnReference><ColumnReference Column="CumulativeTop1035"></ColumnReference><ColumnReference Column="CumulativeBottom1036"></ColumnReference><ColumnReference Column="CumulativeTop1037"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="CumulativeTop1031"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1016])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1016"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="CumulativeTop1033"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1016])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1016"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="CumulativeTop1035"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1017])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1017"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="CumulativeTop1037"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1017])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1017"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Recr1008"></ColumnReference><ScalarOperator ScalarString="ANY([Recr1008])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Recr1008"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1015"></ColumnReference><ScalarOperator ScalarString="ANY([Expr1015])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1015"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1017"></ColumnReference><ScalarOperator ScalarString="ANY([Expr1017])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1017"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="CumulativeBottom1030"></ColumnReference><ScalarOperator ScalarString="ANY([CumulativeBottom1030])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="CumulativeBottom1030"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="CumulativeBottom1032"></ColumnReference><ScalarOperator ScalarString="ANY([CumulativeBottom1032])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="CumulativeBottom1032"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="CumulativeBottom1034"></ColumnReference><ScalarOperator ScalarString="ANY([CumulativeBottom1034])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="CumulativeBottom1034"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="CumulativeBottom1036"></ColumnReference><ScalarOperator ScalarString="ANY([CumulativeBottom1036])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="CumulativeBottom1036"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Column="WindowCount1054"></ColumnReference></GroupBy><RelOp NodeId="7" PhysicalOp="Window Spool" LogicalOp="Window Spool" EstimateRows="4" EstimateIO="0" EstimateCPU="4.396e-06" AvgRowSize="118" EstimatedTotalSubtreeCost="0.0673474" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="CumulativeBottom1030"></ColumnReference><ColumnReference Column="CumulativeBottom1032"></ColumnReference><ColumnReference Column="CumulativeBottom1034"></ColumnReference><ColumnReference Column="CumulativeBottom1036"></ColumnReference><ColumnReference Column="RowNumber1039"></ColumnReference><ColumnReference Column="WindowCount1054"></ColumnReference><ColumnReference Column="Segment1053"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><WindowSpool><RelOp NodeId="8" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="2" EstimateIO="0" EstimateCPU="1.256e-07" AvgRowSize="118" EstimatedTotalSubtreeCost="0.0673425" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="CumulativeBottom1030"></ColumnReference><ColumnReference Column="CumulativeBottom1032"></ColumnReference><ColumnReference Column="CumulativeBottom1034"></ColumnReference><ColumnReference Column="CumulativeBottom1036"></ColumnReference><ColumnReference Column="RowNumber1039"></ColumnReference><ColumnReference Column="BottomRowNumber1040"></ColumnReference><ColumnReference Column="Segment1053"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1053"></ColumnReference></SegmentColumn><RelOp NodeId="9" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2" EstimateIO="0" EstimateCPU="2e-07" AvgRowSize="110" EstimatedTotalSubtreeCost="0.0673424" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="CumulativeBottom1030"></ColumnReference><ColumnReference Column="CumulativeBottom1032"></ColumnReference><ColumnReference Column="CumulativeBottom1034"></ColumnReference><ColumnReference Column="CumulativeBottom1036"></ColumnReference><ColumnReference Column="RowNumber1039"></ColumnReference><ColumnReference Column="BottomRowNumber1040"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="BottomRowNumber1040"></ColumnReference><ScalarOperator ScalarString="[RowNumber1039]-(7)"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="RowNumber1039"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(7)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="10" PhysicalOp="Sequence Project" LogicalOp="Compute Scalar" EstimateRows="2" EstimateIO="0" EstimateCPU="1.6e-07" AvgRowSize="102" EstimatedTotalSubtreeCost="0.0673422" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="CumulativeBottom1030"></ColumnReference><ColumnReference Column="CumulativeBottom1032"></ColumnReference><ColumnReference Column="CumulativeBottom1034"></ColumnReference><ColumnReference Column="CumulativeBottom1036"></ColumnReference><ColumnReference Column="RowNumber1039"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><SequenceProject><DefinedValues><DefinedValue><ColumnReference Column="RowNumber1039"></ColumnReference><ScalarOperator ScalarString="row_number"><Sequence FunctionName="row_number"></Sequence></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="11" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="2" EstimateIO="0" EstimateCPU="4e-08" AvgRowSize="102" EstimatedTotalSubtreeCost="0.067342" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="CumulativeBottom1030"></ColumnReference><ColumnReference Column="CumulativeBottom1032"></ColumnReference><ColumnReference Column="CumulativeBottom1034"></ColumnReference><ColumnReference Column="CumulativeBottom1036"></ColumnReference><ColumnReference Column="Segment1052"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1052"></ColumnReference></SegmentColumn><RelOp NodeId="12" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="1.256e-06" AvgRowSize="68" EstimatedTotalSubtreeCost="0.067342" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="CumulativeBottom1030"></ColumnReference><ColumnReference Column="CumulativeBottom1032"></ColumnReference><ColumnReference Column="CumulativeBottom1034"></ColumnReference><ColumnReference Column="CumulativeBottom1036"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="CumulativeBottom1030"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1016])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1016"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="CumulativeBottom1032"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1016])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1016"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="CumulativeBottom1034"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1017])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1017"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="CumulativeBottom1036"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1017])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1017"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Recr1008"></ColumnReference><ScalarOperator ScalarString="ANY([Recr1008])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Recr1008"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1015"></ColumnReference><ScalarOperator ScalarString="ANY([Expr1015])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1015"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1016"></ColumnReference><ScalarOperator ScalarString="ANY([Expr1016])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1016"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1017"></ColumnReference><ScalarOperator ScalarString="ANY([Expr1017])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1017"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Column="WindowCount1051"></ColumnReference></GroupBy><RelOp NodeId="13" PhysicalOp="Window Spool" LogicalOp="Window Spool" EstimateRows="4" EstimateIO="0" EstimateCPU="4.396e-06" AvgRowSize="68" EstimatedTotalSubtreeCost="0.0673407" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="RowNumber1041"></ColumnReference><ColumnReference Column="WindowCount1051"></ColumnReference><ColumnReference Column="Segment1050"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><WindowSpool><RelOp NodeId="14" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="2" EstimateIO="0" EstimateCPU="1.256e-07" AvgRowSize="68" EstimatedTotalSubtreeCost="0.0673358" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="RowNumber1041"></ColumnReference><ColumnReference Column="Segment1050"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1050"></ColumnReference></SegmentColumn><RelOp NodeId="15" PhysicalOp="Sequence Project" LogicalOp="Compute Scalar" EstimateRows="2" EstimateIO="0" EstimateCPU="1.6e-07" AvgRowSize="60" EstimatedTotalSubtreeCost="0.0673357" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="RowNumber1041"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><SequenceProject><DefinedValues><DefinedValue><ColumnReference Column="RowNumber1041"></ColumnReference><ScalarOperator ScalarString="row_number"><Sequence FunctionName="row_number"></Sequence></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="16" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="2" EstimateIO="0" EstimateCPU="4e-08" AvgRowSize="60" EstimatedTotalSubtreeCost="0.0673355" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Segment1049"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1049"></ColumnReference></SegmentColumn><RelOp NodeId="17" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2" EstimateIO="0" EstimateCPU="0" AvgRowSize="52" EstimatedTotalSubtreeCost="0.0673355" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1015"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1047]=(0) THEN NULL ELSE [Expr1048]/CONVERT_IMPLICIT(numeric(19,0),[Expr1047],0) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1047"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Expr1048"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="numeric" Precision="19" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1047"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1016"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1047]=(0) THEN NULL ELSE [Expr1048] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1047"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1048"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1017"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1047],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1047"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="18" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="4.2e-06" AvgRowSize="52" EstimatedTotalSubtreeCost="0.0673355" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1047"></ColumnReference><ColumnReference Column="Expr1048"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1047"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([fiddle_a20b6110517f40fda77f09099ce56244].[dbo].[sales].[price] as [s].[price])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Alias="[s]" Column="price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1048"></ColumnReference><ScalarOperator ScalarString="SUM([fiddle_a20b6110517f40fda77f09099ce56244].[dbo].[sales].[price] as [s].[price])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Alias="[s]" Column="price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Recr1008"></ColumnReference></GroupBy><RelOp NodeId="19" PhysicalOp="Nested Loops" LogicalOp="Left Outer Join" EstimateRows="5.33333" EstimateIO="0" EstimateCPU="6.688e-05" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0673313" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Alias="[s]" Column="price"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><Predicate><ScalarOperator ScalarString="[fiddle_a20b6110517f40fda77f09099ce56244].[dbo].[sales].[date] as [s].[date]=[Recr1008] AND [fiddle_a20b6110517f40fda77f09099ce56244].[dbo].[sales].[productId] as [s].[productId]=[fiddle_a20b6110517f40fda77f09099ce56244].[dbo].[sales].[productId]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Alias="[s]" Column="date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Recr1008"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Alias="[s]" Column="productId"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate><RelOp NodeId="20" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="4" EstimateIO="0.0112613" EstimateCPU="0.000112494" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0637181" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference></OutputList><MemoryFractions Input="0.5" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="544" OutputMemoryGrant="192" UsedMemoryGrant="16" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Recr1008"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="21" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="4" EstimateIO="0" EstimateCPU="1.672e-05" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0523444" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><RelOp NodeId="22" PhysicalOp="Index Spool" LogicalOp="Lazy Spool" EstimateRows="4" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="10" EstimatedTotalSubtreeCost="0.00329756" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1046"></ColumnReference><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Column="Recr1009"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="7" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Spool Stack="1"><RelOp NodeId="23" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="4" EstimateIO="0" EstimateCPU="2e-09" AvgRowSize="10" EstimatedTotalSubtreeCost="0.00329597" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1046"></ColumnReference><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Column="Recr1009"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Concat><DefinedValues><DefinedValue><ColumnReference Column="Expr1046"></ColumnReference><ColumnReference Column="Expr1043"></ColumnReference><ColumnReference Column="Expr1045"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Recr1009"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Recr1006"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="24" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="2e-08" AvgRowSize="10" EstimatedTotalSubtreeCost="2e-08" Parallel="0" EstimateRebinds="4" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1043"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1043"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="25" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="2.9e-06" AvgRowSize="13" EstimatedTotalSubtreeCost="0.0032893" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1003"></ColumnReference><ScalarOperator ScalarString="MIN([fiddle_a20b6110517f40fda77f09099ce56244].[dbo].[sales].[date])"><Aggregate Distinct="0" AggType="MIN"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="date"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1004"></ColumnReference><ScalarOperator ScalarString="MAX([fiddle_a20b6110517f40fda77f09099ce56244].[dbo].[sales].[date])"><Aggregate Distinct="0" AggType="MAX"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="date"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="26" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="4" EstimatedRowsRead="4" EstimateIO="0.003125" EstimateCPU="0.0001614" AvgRowSize="10" EstimatedTotalSubtreeCost="0.0032864" TableCardinality="4" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="date"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="1" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="4" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="date"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" TableReferenceId="1" IndexKind="Heap" Storage="RowStore"></Object></TableScan></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp><RelOp NodeId="27" PhysicalOp="Assert" LogicalOp="Assert" EstimateRows="4" EstimateIO="0" EstimateCPU="1.68e-07" AvgRowSize="10" EstimatedTotalSubtreeCost="6.665e-06" Parallel="0" EstimateRebinds="4" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1045"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Recr1006"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Assert StartupExpression="0"><RelOp NodeId="28" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="4" EstimateIO="0" EstimateCPU="1.68e-07" AvgRowSize="10" EstimatedTotalSubtreeCost="6.665e-06" Parallel="0" EstimateRebinds="4" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1045"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Recr1006"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Column="Expr1045"></ColumnReference><ColumnReference Column="Recr1005"></ColumnReference><ColumnReference Column="Recr1006"></ColumnReference></OuterReferences><RelOp NodeId="29" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="2e-08" AvgRowSize="10" EstimatedTotalSubtreeCost="2e-08" Parallel="0" EstimateRebinds="4" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1045"></ColumnReference><ColumnReference Column="Recr1005"></ColumnReference><ColumnReference Column="Recr1006"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1045"></ColumnReference><ScalarOperator ScalarString="[Expr1044]+(1)"><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Column="Expr1044"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="30" PhysicalOp="Table Spool" LogicalOp="Lazy Spool" EstimateRows="1" EstimateIO="0" EstimateCPU="2e-08" AvgRowSize="10" EstimatedTotalSubtreeCost="2e-08" Parallel="0" EstimateRebinds="4" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1044"></ColumnReference><ColumnReference Column="Recr1005"></ColumnReference><ColumnReference Column="Recr1006"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Spool PrimaryNodeId="22" Stack="1"></Spool></RelOp></ComputeScalar></RelOp><RelOp NodeId="31" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="10" EstimatedTotalSubtreeCost="6.477e-06" Parallel="0" EstimateRebinds="3" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1007"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1007"></ColumnReference><ScalarOperator ScalarString="dateadd(day,(1),[Recr1005])"><Intrinsic FunctionName="dateadd"><ScalarOperator><Const ConstValue="(4)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Recr1005"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="32" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1" EstimateIO="0" EstimateCPU="4.8e-07" AvgRowSize="9" EstimatedTotalSubtreeCost="6.077e-06" Parallel="0" EstimateRebinds="3" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualRebinds="3" ActualRewinds="0" ActualEndOfScans="3" ActualExecutions="3" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="1"><RelOp NodeId="33" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-06" AvgRowSize="9" EstimatedTotalSubtreeCost="4.157e-06" Parallel="0" EstimateRebinds="0" EstimateRewinds="3" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="2" ActualExecutions="2" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp><Predicate><ScalarOperator ScalarString="[Recr1005]&lt;[Recr1006]"><Compare CompareOp="LT"><ScalarOperator><Identifier><ColumnReference Column="Recr1005"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Recr1006"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></ComputeScalar></RelOp></NestedLoops></RelOp><Predicate><ScalarOperator ScalarString="CASE WHEN [Expr1045]&gt;(100) THEN (0) ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Column="Expr1045"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(100)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Predicate></Assert></RelOp></Concat></RelOp></Spool></RelOp><RelOp NodeId="34" PhysicalOp="Sort" LogicalOp="Distinct Sort" EstimateRows="1" EstimateIO="0.0112613" EstimateCPU="0.000112491" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0490301" Parallel="0" EstimateRebinds="0" EstimateRewinds="3" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference></OutputList><MemoryFractions Input="0.5" Output="0.5"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="2" ActualEndOfScans="3" ActualExecutions="3" InputMemoryGrant="544" OutputMemoryGrant="160" UsedMemoryGrant="16" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="1"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="35" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="4" EstimatedRowsRead="4" EstimateIO="0.0032035" EstimateCPU="8.29e-05" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0035351" TableCardinality="4" Parallel="0" EstimateRebinds="0" EstimateRewinds="3" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="12" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="3" ActualLogicalReads="3" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="12" ActualEndOfScans="3" ActualExecutions="3" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" TableReferenceId="2" IndexKind="Heap" Storage="RowStore"></Object></TableScan></RelOp></Sort></RelOp></NestedLoops></RelOp></Sort></RelOp><RelOp NodeId="36" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="4" EstimatedRowsRead="4" EstimateIO="0.0032035" EstimateCPU="8.29e-05" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0035351" TableCardinality="4" Parallel="0" EstimateRebinds="0" EstimateRewinds="3" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Alias="[s]" Column="productId"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Alias="[s]" Column="date"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Alias="[s]" Column="price"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="12" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="3" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="12" ActualEndOfScans="3" ActualExecutions="3" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Alias="[s]" Column="productId"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Alias="[s]" Column="date"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Alias="[s]" Column="price"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Alias="[s]" IndexKind="Heap" Storage="RowStore"></Object></TableScan></RelOp></NestedLoops></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp></Segment></RelOp></SequenceProject></RelOp></Segment></RelOp></WindowSpool></RelOp></StreamAggregate></RelOp></Segment></RelOp></SequenceProject></RelOp></ComputeScalar></RelOp></Segment></RelOp></WindowSpool></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></Segment></RelOp></Spool></RelOp><RelOp NodeId="37" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="2" EstimateIO="0" EstimateCPU="4.686e-07" AvgRowSize="56" EstimatedTotalSubtreeCost="9.372e-07" Parallel="0" EstimateRebinds="1" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="2" ActualExecutions="2" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><Predicate><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator></Predicate><RelOp NodeId="38" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="4.686e-08" AvgRowSize="56" EstimatedTotalSubtreeCost="5.1546e-07" Parallel="0" EstimateRebinds="1" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1020"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1056]=(0) THEN NULL ELSE [Expr1057] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1056"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1057"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="39" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="4.686e-07" AvgRowSize="56" EstimatedTotalSubtreeCost="4.686e-07" Parallel="0" EstimateRebinds="1" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1056"></ColumnReference><ColumnReference Column="Expr1057"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="2" ActualExecutions="2" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1056"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1017])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1017"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1057"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1017])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1017"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="40" PhysicalOp="Table Spool" LogicalOp="Lazy Spool" EstimateRows="2" EstimateIO="0" EstimateCPU="0" AvgRowSize="56" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="1" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="1" ActualEndOfScans="2" ActualExecutions="2" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Spool PrimaryNodeId="2"></Spool></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp><RelOp NodeId="41" PhysicalOp="Table Spool" LogicalOp="Lazy Spool" EstimateRows="2" EstimateIO="0" EstimateCPU="0" AvgRowSize="56" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="1" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Database="[fiddle_a20b6110517f40fda77f09099ce56244]" Schema="[dbo]" Table="[sales]" Column="productId"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="0" ActualRewinds="1" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Spool PrimaryNodeId="2"></Spool></RelOp></NestedLoops></RelOp></NestedLoops></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
productId	date	price
1	2025-02-01	10.00
1	2025-02-02	20.00
1	2025-02-02	30.00
1	2025-02-03	40.00
productid	salesDate	avg1DayPrice	avg7DayPrice
1	2025-02-01	10.000000	10.000000
1	2025-02-02	25.000000	20.000000
1	2025-02-03	40.000000	25.000000
productid	salesDate	avg1DayPrice	avg7DayPrice
1	2025-02-01	10.000000	2.500000
1	2025-02-02	25.000000	15.000000
1	2025-02-03	40.000000	25.000000