<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.612" Build="18.0.277.116"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT&#xa;TOP 100&#xa;  *&#xa;FROM (&#xa;  SELECT&#xa;    AVG(ss_list_price) AS B1_LP,&#xa;    COUNT(ss_list_price) AS B1_CNT,&#xa;    COUNT(DISTINCT ss_list_price) AS B1_CNTD&#xa;  FROM store_sales&#xa;  WHERE&#xa;    ss_quantity BETWEEN 0 AND 5&#xa;    AND (&#xa;      ss_list_price BETWEEN 37 AND 37 + 10&#xa;      OR ss_coupon_amt BETWEEN 5355 AND 5355 + 1000&#xa;      OR ss_wholesale_cost BETWEEN 21 AND 21 + 20&#xa;    )&#xa;) AS B1, (&#xa;  SELECT&#xa;    AVG(ss_list_price) AS B2_LP,&#xa;    COUNT(ss_list_price) AS B2_CNT,&#xa;    COUNT(DISTINCT ss_list_price) AS B2_CNTD&#xa;  FROM store_sales&#xa;  WHERE&#xa;    ss_quantity BETWEEN 6 AND 10&#xa;    AND (&#xa;      ss_list_price BETWEEN 31 AND 31 + 10&#xa;      OR ss_coupon_amt BETWEEN 4881 AND 4881 + 1000&#xa;      OR ss_wholesale_cost BETWEEN 58 AND 58 + 20&#xa;    )&#xa;) AS B2, (&#xa;  SELECT&#xa;    AVG(ss_list_price) AS B3_LP,&#xa;    COUNT(ss_list_price) AS B3_CNT,&#xa;    COUNT(DISTINCT ss_list_price) AS B3_CNTD&#xa;  FROM store_sales&#xa;  WHERE&#xa;    ss_quantity BETWEEN 11 AND 15&#xa;    AND (&#xa;      ss_list_price BETWEEN 75 AND 75 + 10&#xa;      OR ss_coupon_amt BETWEEN 6515 AND 6515 + 1000&#xa;      OR ss_wholesale_cost BETWEEN 28 AND 28 + 20&#xa;    )&#xa;) AS B3, (&#xa;  SELECT&#xa;    AVG(ss_list_price) AS B4_LP,&#xa;    COUNT(ss_list_price) AS B4_CNT,&#xa;    COUNT(DISTINCT ss_list_price) AS B4_CNTD&#xa;  FROM store_sales&#xa;  WHERE&#xa;    ss_quantity BETWEEN 16 AND 20&#xa;    AND (&#xa;      ss_list_price BETWEEN 39 AND 39 + 10&#xa;      OR ss_coupon_amt BETWEEN 1881 AND 1881 + 1000&#xa;      OR ss_wholesale_cost BETWEEN 25 AND 25 + 20&#xa;    )&#xa;) AS B4, (&#xa;  SELECT&#xa;    AVG(ss_list_price) AS B5_LP,&#xa;    COUNT(ss_list_price) AS B5_CNT,&#xa;    COUNT(DISTINCT ss_list_price) AS B5_CNTD&#xa;  FROM store_sales&#xa;  WHERE&#xa;    ss_quantity BETWEEN 21 AND 25&#xa;    AND (&#xa;      ss_list_price BETWEEN 84 AND 84 + 10&#xa;      OR ss_coupon_amt BETWEEN 1100 AND 1100 + 1000&#xa;      OR ss_wholesale_cost BETWEEN 64 AND 64 + 20&#xa;    )&#xa;) AS B5, (&#xa;  SELECT&#xa;    AVG(ss_list_price) AS B6_LP,&#xa;    COUNT(ss_list_price) AS B6_CNT,&#xa;    COUNT(DISTINCT ss_list_price) AS B6_CNTD&#xa;  FROM store_sales&#xa;  WHERE&#xa;    ss_quantity BETWEEN 26 AND 30&#xa;    AND (&#xa;      ss_list_price BETWEEN 24 AND 24 + 10&#xa;      OR ss_coupon_amt BETWEEN 5272 AND 5272 + 1000&#xa;      OR ss_wholesale_cost BETWEEN 30 AND 30 + 20&#xa;    )&#xa;) AS B6" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="3445.29" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x1BA2CFC947D8ACB4" QueryPlanHash="0x2F6455AF4EC73DFF" CardinalityEstimationModelVersion="160"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan NonParallelPlanReason="NoParallelForPDWCompilation" CachedPlanSize="1008" CompileTime="98" CompileCPU="98" CompileMemory="8488"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="524288" EstimatedPagesCached="488960" EstimatedAvailableDegreeOfParallelism="6" MaxCompileMemory="17544600"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2026-10-03T15:32:48.75" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000B_05D8E0BE]" Table="[store_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:34:50.48" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000C_05D8E0BE]" Table="[store_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:34:48.26" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000014_05D8E0BE]" Table="[store_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:33:28.48" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000D_05D8E0BE]" Table="[store_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="5e-08" AvgRowSize="159" EstimatedTotalSubtreeCost="3445.29" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference><ColumnReference Column="Expr1029"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1002"></ColumnReference><ScalarOperator ScalarString="[Expr1002]"><Identifier><ColumnReference Column="Expr1002"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1003"></ColumnReference><ScalarOperator ScalarString="[Expr1003]"><Identifier><ColumnReference Column="Expr1003"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1004"></ColumnReference><ScalarOperator ScalarString="[Expr1004]"><Identifier><ColumnReference Column="Expr1004"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1007"></ColumnReference><ScalarOperator ScalarString="[Expr1007]"><Identifier><ColumnReference Column="Expr1007"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1008"></ColumnReference><ScalarOperator ScalarString="[Expr1008]"><Identifier><ColumnReference Column="Expr1008"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1009"></ColumnReference><ScalarOperator ScalarString="[Expr1009]"><Identifier><ColumnReference Column="Expr1009"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1012"></ColumnReference><ScalarOperator ScalarString="[Expr1012]"><Identifier><ColumnReference Column="Expr1012"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1013"></ColumnReference><ScalarOperator ScalarString="[Expr1013]"><Identifier><ColumnReference Column="Expr1013"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1014"></ColumnReference><ScalarOperator ScalarString="[Expr1014]"><Identifier><ColumnReference Column="Expr1014"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1017"></ColumnReference><ScalarOperator ScalarString="[Expr1017]"><Identifier><ColumnReference Column="Expr1017"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1018"></ColumnReference><ScalarOperator ScalarString="[Expr1018]"><Identifier><ColumnReference Column="Expr1018"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1019"></ColumnReference><ScalarOperator ScalarString="[Expr1019]"><Identifier><ColumnReference Column="Expr1019"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1022"></ColumnReference><ScalarOperator ScalarString="[Expr1022]"><Identifier><ColumnReference Column="Expr1022"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1023"></ColumnReference><ScalarOperator ScalarString="[Expr1023]"><Identifier><ColumnReference Column="Expr1023"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1024"></ColumnReference><ScalarOperator ScalarString="[Expr1024]"><Identifier><ColumnReference Column="Expr1024"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1027"></ColumnReference><ScalarOperator ScalarString="[Expr1027]"><Identifier><ColumnReference Column="Expr1027"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1028"></ColumnReference><ScalarOperator ScalarString="[Expr1028]"><Identifier><ColumnReference Column="Expr1028"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1029"></ColumnReference><ScalarOperator ScalarString="[Expr1029]"><Identifier><ColumnReference Column="Expr1029"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="1" EstimateIO="0" EstimateCPU="5e-08" AvgRowSize="159" EstimatedTotalSubtreeCost="3445.29" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference><ColumnReference Column="Expr1029"></ColumnReference></OutputList><Move DistributionType="Return" MoveTopology="OneToOne"><RelOp NodeId="3" PhysicalOp="Top" LogicalOp="Top" EstimateRows="1" EstimateIO="0" EstimateCPU="5e-08" AvgRowSize="159" EstimatedTotalSubtreeCost="3445.29" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference><ColumnReference Column="Expr1029"></ColumnReference></OutputList><Top RowCount="0" IsPercent="0" WithTies="0"><TopExpression><ScalarOperator ScalarString="(100)"><Const ConstValue="(100)"></Const></ScalarOperator></TopExpression><RelOp NodeId="4" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="1" EstimateIO="0.023125" EstimateCPU="2.1e-06" AvgRowSize="159" EstimatedTotalSubtreeCost="3445.29" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference><ColumnReference Column="Expr1029"></ColumnReference></OutputList><Move DistributionType="Gather" MoveTopology="ManyToOne"><RelOp NodeId="5" PhysicalOp="Top" LogicalOp="Top" EstimateRows="1" EstimateIO="0" EstimateCPU="5e-08" AvgRowSize="159" EstimatedTotalSubtreeCost="3445.25" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference><ColumnReference Column="Expr1029"></ColumnReference></OutputList><Top RowCount="0" IsPercent="0" WithTies="0"><TopExpression><ScalarOperator ScalarString="(100)"><Const ConstValue="(100)"></Const></ScalarOperator></TopExpression><RelOp NodeId="6" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0017776" AvgRowSize="159" EstimatedTotalSubtreeCost="3445.25" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference><ColumnReference Column="Expr1029"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1114"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Expr1115"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Expr1114]=[Expr1115]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1114"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1115"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="7" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="36" EstimatedTotalSubtreeCost="574.189" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1114"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1114"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="9" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="32" EstimatedTotalSubtreeCost="574.189" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1002"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [globalagg1031]=(0) THEN NULL ELSE [globalagg1033]/CONVERT_IMPLICIT(decimal(19,0),[globalagg1031],0) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="globalagg1031"></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="globalagg1033"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="19" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1031"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1003"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[globalagg1035],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1035"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="11" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="44" EstimatedTotalSubtreeCost="574.189" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="globalagg1031"></ColumnReference><ColumnReference Column="globalagg1033"></ColumnReference><ColumnReference Column="globalagg1035"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1004"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[globalagg1037],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1037"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="12" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0017751" AvgRowSize="48" EstimatedTotalSubtreeCost="574.189" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="globalagg1031"></ColumnReference><ColumnReference Column="globalagg1033"></ColumnReference><ColumnReference Column="globalagg1035"></ColumnReference><ColumnReference Column="globalagg1037"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="globalagg1037"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1036])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1036"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1031"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1041])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1041"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1033"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1042])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1042"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1035"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1043])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1043"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="13" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="2" EstimateIO="0.023125" EstimateCPU="4.2e-06" AvgRowSize="48" EstimatedTotalSubtreeCost="574.187" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="partialagg1036"></ColumnReference><ColumnReference Column="partialagg1041"></ColumnReference><ColumnReference Column="partialagg1042"></ColumnReference><ColumnReference Column="partialagg1043"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="14" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="0.00187395" AvgRowSize="48" EstimatedTotalSubtreeCost="574.154" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="partialagg1036"></ColumnReference><ColumnReference Column="partialagg1041"></ColumnReference><ColumnReference Column="partialagg1042"></ColumnReference><ColumnReference Column="partialagg1043"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1036"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([TPCDS_SF100].[dbo].[store_sales].[ss_list_price])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1041"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1030])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1030"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1042"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1032])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1032"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1043"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1034])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1034"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="15" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="19760" EstimateIO="0" EstimateCPU="0.054777" AvgRowSize="45" EstimatedTotalSubtreeCost="574.152" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Column="partialagg1030"></ColumnReference><ColumnReference Column="partialagg1032"></ColumnReference><ColumnReference Column="partialagg1034"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1030"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1038])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1038"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1032"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1039])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1039"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1034"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1040])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1040"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_list_price] = [TPCDS_SF100].[dbo].[store_sales].[ss_list_price]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="16" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="39520" EstimateIO="1.5561" EstimateCPU="0.041496" AvgRowSize="45" EstimatedTotalSubtreeCost="574.098" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Column="partialagg1038"></ColumnReference><ColumnReference Column="partialagg1039"></ColumnReference><ColumnReference Column="partialagg1040"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></DistributionKey><RelOp NodeId="17" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="39520" EstimateIO="0" EstimateCPU="0" AvgRowSize="45" EstimatedTotalSubtreeCost="571.759" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Column="partialagg1038"></ColumnReference><ColumnReference Column="partialagg1039"></ColumnReference><ColumnReference Column="partialagg1040"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1040"></ColumnReference><ScalarOperator ScalarString="[partialagg1038]"><Identifier><ColumnReference Column="partialagg1038"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="18" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="39520" EstimateIO="0" EstimateCPU="2.19035" AvgRowSize="45" EstimatedTotalSubtreeCost="571.759" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Column="partialagg1038"></ColumnReference><ColumnReference Column="partialagg1039"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1038"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([TPCDS_SF100].[dbo].[store_sales].[ss_list_price])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1039"></ColumnReference><ScalarOperator ScalarString="SUM([TPCDS_SF100].[dbo].[store_sales].[ss_list_price])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_list_price] = [TPCDS_SF100].[dbo].[store_sales].[ss_list_price]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="19" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="6.44275e+06" EstimateIO="0" EstimateCPU="418.427" AvgRowSize="12" EstimatedTotalSubtreeCost="569.569" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="20" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="6.44275e+06" EstimatedRowsRead="2.87777e+08" EstimateIO="135.314" EstimateCPU="15.8277" AvgRowSize="26" EstimatedTotalSubtreeCost="151.142" TableCardinality="2.87777e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_wholesale_cost"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_wholesale_cost"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_quantity]&gt;=(0) AND [TPCDS_SF100].[dbo].[store_sales].[ss_quantity]&lt;=(5)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(5)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_list_price]&gt;=(37.00) AND [TPCDS_SF100].[dbo].[store_sales].[ss_list_price]&lt;=(47) OR [TPCDS_SF100].[dbo].[store_sales].[ss_coupon_amt]&gt;=(5355.00) AND [TPCDS_SF100].[dbo].[store_sales].[ss_coupon_amt]&lt;=(6355) OR [TPCDS_SF100].[dbo].[store_sales].[ss_wholesale_cost]&gt;=(21.00) AND [TPCDS_SF100].[dbo].[store_sales].[ss_wholesale_cost]&lt;=(41)"><Logical Operation="OR"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(37.00)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(47)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(5355.00)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(6355)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_wholesale_cost"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(21.00)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_wholesale_cost"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(41)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp></Hash></RelOp></ComputeScalar></RelOp></Move></RelOp></Hash></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp><RelOp NodeId="21" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="5e-09" AvgRowSize="137" EstimatedTotalSubtreeCost="2871.06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference><ColumnReference Column="Expr1029"></ColumnReference><ColumnReference Column="Expr1115"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1115"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="22" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0017776" AvgRowSize="133" EstimatedTotalSubtreeCost="2871.06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference><ColumnReference Column="Expr1029"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1114"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Expr1115"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Expr1114]=[Expr1115]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1114"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1115"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="23" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="36" EstimatedTotalSubtreeCost="574.201" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1114"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1114"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="25" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="32" EstimatedTotalSubtreeCost="574.201" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1007"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [globalagg1101]=(0) THEN NULL ELSE [globalagg1103]/CONVERT_IMPLICIT(decimal(19,0),[globalagg1101],0) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="globalagg1101"></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="globalagg1103"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="19" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1101"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1008"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[globalagg1105],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1105"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="27" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="44" EstimatedTotalSubtreeCost="574.201" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="globalagg1101"></ColumnReference><ColumnReference Column="globalagg1103"></ColumnReference><ColumnReference Column="globalagg1105"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1009"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[globalagg1107],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1107"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="28" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0017751" AvgRowSize="48" EstimatedTotalSubtreeCost="574.201" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="globalagg1101"></ColumnReference><ColumnReference Column="globalagg1103"></ColumnReference><ColumnReference Column="globalagg1105"></ColumnReference><ColumnReference Column="globalagg1107"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="globalagg1107"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1106])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1106"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1101"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1111])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1111"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1103"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1112])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1112"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1105"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1113])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1113"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="29" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="2" EstimateIO="0.023125" EstimateCPU="4.2e-06" AvgRowSize="48" EstimatedTotalSubtreeCost="574.199" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="partialagg1106"></ColumnReference><ColumnReference Column="partialagg1111"></ColumnReference><ColumnReference Column="partialagg1112"></ColumnReference><ColumnReference Column="partialagg1113"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="30" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="0.00187395" AvgRowSize="48" EstimatedTotalSubtreeCost="574.166" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="partialagg1106"></ColumnReference><ColumnReference Column="partialagg1111"></ColumnReference><ColumnReference Column="partialagg1112"></ColumnReference><ColumnReference Column="partialagg1113"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1106"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([TPCDS_SF100].[dbo].[store_sales].[ss_list_price])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1111"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1100])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1100"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1112"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1102])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1102"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1113"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1104])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1104"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="31" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="19760" EstimateIO="0" EstimateCPU="0.054777" AvgRowSize="45" EstimatedTotalSubtreeCost="574.164" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Column="partialagg1100"></ColumnReference><ColumnReference Column="partialagg1102"></ColumnReference><ColumnReference Column="partialagg1104"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1100"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1108])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1108"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1102"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1109])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1109"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1104"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1110])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1110"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_list_price] = [TPCDS_SF100].[dbo].[store_sales].[ss_list_price]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="32" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="39520" EstimateIO="1.5561" EstimateCPU="0.041496" AvgRowSize="45" EstimatedTotalSubtreeCost="574.109" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Column="partialagg1108"></ColumnReference><ColumnReference Column="partialagg1109"></ColumnReference><ColumnReference Column="partialagg1110"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></DistributionKey><RelOp NodeId="33" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="39520" EstimateIO="0" EstimateCPU="0" AvgRowSize="45" EstimatedTotalSubtreeCost="571.771" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Column="partialagg1108"></ColumnReference><ColumnReference Column="partialagg1109"></ColumnReference><ColumnReference Column="partialagg1110"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1110"></ColumnReference><ScalarOperator ScalarString="[partialagg1108]"><Identifier><ColumnReference Column="partialagg1108"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="34" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="39520" EstimateIO="0" EstimateCPU="2.20207" AvgRowSize="45" EstimatedTotalSubtreeCost="571.771" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Column="partialagg1108"></ColumnReference><ColumnReference Column="partialagg1109"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1108"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([TPCDS_SF100].[dbo].[store_sales].[ss_list_price])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1109"></ColumnReference><ScalarOperator ScalarString="SUM([TPCDS_SF100].[dbo].[store_sales].[ss_list_price])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_list_price] = [TPCDS_SF100].[dbo].[store_sales].[ss_list_price]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="35" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="6.47784e+06" EstimateIO="0" EstimateCPU="418.427" AvgRowSize="12" EstimatedTotalSubtreeCost="569.569" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="36" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="6.47784e+06" EstimatedRowsRead="2.87777e+08" EstimateIO="135.314" EstimateCPU="15.8277" AvgRowSize="26" EstimatedTotalSubtreeCost="151.142" TableCardinality="2.87777e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_wholesale_cost"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_wholesale_cost"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_quantity]&gt;=(6) AND [TPCDS_SF100].[dbo].[store_sales].[ss_quantity]&lt;=(10)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(6)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(10)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_list_price]&gt;=(31.00) AND [TPCDS_SF100].[dbo].[store_sales].[ss_list_price]&lt;=(41) OR [TPCDS_SF100].[dbo].[store_sales].[ss_coupon_amt]&gt;=(4881.00) AND [TPCDS_SF100].[dbo].[store_sales].[ss_coupon_amt]&lt;=(5881) OR [TPCDS_SF100].[dbo].[store_sales].[ss_wholesale_cost]&gt;=(58.00) AND [TPCDS_SF100].[dbo].[store_sales].[ss_wholesale_cost]&lt;=(78)"><Logical Operation="OR"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(31.00)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(41)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(4881.00)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(5881)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_wholesale_cost"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(58.00)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_wholesale_cost"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(78)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp></Hash></RelOp></ComputeScalar></RelOp></Move></RelOp></Hash></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp><RelOp NodeId="37" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="5e-09" AvgRowSize="112" EstimatedTotalSubtreeCost="2296.86" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference><ColumnReference Column="Expr1029"></ColumnReference><ColumnReference Column="Expr1115"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1115"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="38" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0017776" AvgRowSize="108" EstimatedTotalSubtreeCost="2296.86" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference><ColumnReference Column="Expr1029"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1114"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Expr1115"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Expr1114]=[Expr1115]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1114"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1115"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="39" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="36" EstimatedTotalSubtreeCost="574.218" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1022"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1114"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1114"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="41" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="32" EstimatedTotalSubtreeCost="574.218" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1022"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1022"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [globalagg1059]=(0) THEN NULL ELSE [globalagg1061]/CONVERT_IMPLICIT(decimal(19,0),[globalagg1059],0) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="globalagg1059"></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="globalagg1061"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="19" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1059"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1023"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[globalagg1063],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1063"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="43" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="44" EstimatedTotalSubtreeCost="574.218" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="globalagg1059"></ColumnReference><ColumnReference Column="globalagg1061"></ColumnReference><ColumnReference Column="globalagg1063"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1024"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[globalagg1065],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1065"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="44" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0017751" AvgRowSize="48" EstimatedTotalSubtreeCost="574.218" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="globalagg1059"></ColumnReference><ColumnReference Column="globalagg1061"></ColumnReference><ColumnReference Column="globalagg1063"></ColumnReference><ColumnReference Column="globalagg1065"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="globalagg1065"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1064])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1064"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1059"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1069])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1069"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1061"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1070])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1070"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1063"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1071])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1071"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="45" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="2" EstimateIO="0.023125" EstimateCPU="4.2e-06" AvgRowSize="48" EstimatedTotalSubtreeCost="574.216" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="partialagg1064"></ColumnReference><ColumnReference Column="partialagg1069"></ColumnReference><ColumnReference Column="partialagg1070"></ColumnReference><ColumnReference Column="partialagg1071"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="46" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="0.00187395" AvgRowSize="48" EstimatedTotalSubtreeCost="574.183" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="partialagg1064"></ColumnReference><ColumnReference Column="partialagg1069"></ColumnReference><ColumnReference Column="partialagg1070"></ColumnReference><ColumnReference Column="partialagg1071"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1064"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([TPCDS_SF100].[dbo].[store_sales].[ss_list_price])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1069"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1058])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1058"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1070"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1060])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1060"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1071"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1062])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1062"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="47" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="19760" EstimateIO="0" EstimateCPU="0.054777" AvgRowSize="45" EstimatedTotalSubtreeCost="574.181" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Column="partialagg1058"></ColumnReference><ColumnReference Column="partialagg1060"></ColumnReference><ColumnReference Column="partialagg1062"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1058"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1066])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1066"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1060"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1067])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1067"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1062"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1068])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1068"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_list_price] = [TPCDS_SF100].[dbo].[store_sales].[ss_list_price]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="48" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="39520" EstimateIO="1.5561" EstimateCPU="0.041496" AvgRowSize="45" EstimatedTotalSubtreeCost="574.126" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Column="partialagg1066"></ColumnReference><ColumnReference Column="partialagg1067"></ColumnReference><ColumnReference Column="partialagg1068"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></DistributionKey><RelOp NodeId="49" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="39520" EstimateIO="0" EstimateCPU="0" AvgRowSize="45" EstimatedTotalSubtreeCost="571.788" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Column="partialagg1066"></ColumnReference><ColumnReference Column="partialagg1067"></ColumnReference><ColumnReference Column="partialagg1068"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1068"></ColumnReference><ScalarOperator ScalarString="[partialagg1066]"><Identifier><ColumnReference Column="partialagg1066"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="50" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="39520" EstimateIO="0" EstimateCPU="2.21927" AvgRowSize="45" EstimatedTotalSubtreeCost="571.788" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Column="partialagg1066"></ColumnReference><ColumnReference Column="partialagg1067"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1066"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([TPCDS_SF100].[dbo].[store_sales].[ss_list_price])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1067"></ColumnReference><ScalarOperator ScalarString="SUM([TPCDS_SF100].[dbo].[store_sales].[ss_list_price])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_list_price] = [TPCDS_SF100].[dbo].[store_sales].[ss_list_price]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="51" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="6.52936e+06" EstimateIO="0" EstimateCPU="418.427" AvgRowSize="12" EstimatedTotalSubtreeCost="569.569" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="52" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="6.52936e+06" EstimatedRowsRead="2.87777e+08" EstimateIO="135.314" EstimateCPU="15.8277" AvgRowSize="26" EstimatedTotalSubtreeCost="151.142" TableCardinality="2.87777e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_wholesale_cost"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_wholesale_cost"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="5" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_quantity]&gt;=(21) AND [TPCDS_SF100].[dbo].[store_sales].[ss_quantity]&lt;=(25)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(21)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(25)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_list_price]&gt;=(84.00) AND [TPCDS_SF100].[dbo].[store_sales].[ss_list_price]&lt;=(94) OR [TPCDS_SF100].[dbo].[store_sales].[ss_coupon_amt]&gt;=(1100.00) AND [TPCDS_SF100].[dbo].[store_sales].[ss_coupon_amt]&lt;=(2100) OR [TPCDS_SF100].[dbo].[store_sales].[ss_wholesale_cost]&gt;=(64.00) AND [TPCDS_SF100].[dbo].[store_sales].[ss_wholesale_cost]&lt;=(84)"><Logical Operation="OR"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(84.00)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(94)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1100.00)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2100)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_wholesale_cost"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(64.00)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_wholesale_cost"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(84)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp></Hash></RelOp></ComputeScalar></RelOp></Move></RelOp></Hash></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp><RelOp NodeId="53" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="5e-09" AvgRowSize="87" EstimatedTotalSubtreeCost="1722.64" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference><ColumnReference Column="Expr1029"></ColumnReference><ColumnReference Column="Expr1115"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1115"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="54" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="0.00177724" AvgRowSize="83" EstimatedTotalSubtreeCost="1722.64" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference><ColumnReference Column="Expr1029"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1114"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Expr1115"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Expr1114]=[Expr1115]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1114"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1115"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="55" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="5e-09" AvgRowSize="61" EstimatedTotalSubtreeCost="1148.44" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1114"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1114"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="56" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="0.00177668" AvgRowSize="57" EstimatedTotalSubtreeCost="1148.44" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1114"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Expr1115"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Expr1114]=[Expr1115]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1114"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1115"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="57" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="5e-09" AvgRowSize="36" EstimatedTotalSubtreeCost="574.231" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="Expr1114"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1114"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="59" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="5e-09" AvgRowSize="32" EstimatedTotalSubtreeCost="574.231" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1012"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [globalagg1087]=(0) THEN NULL ELSE [globalagg1089]/CONVERT_IMPLICIT(decimal(19,0),[globalagg1087],0) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="globalagg1087"></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="globalagg1089"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="19" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1087"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1013"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[globalagg1091],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1091"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="61" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="5e-09" AvgRowSize="44" EstimatedTotalSubtreeCost="574.231" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="globalagg1087"></ColumnReference><ColumnReference Column="globalagg1089"></ColumnReference><ColumnReference Column="globalagg1091"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1014"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[globalagg1093],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1093"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="62" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="1" EstimateIO="0.023125" EstimateCPU="2.1e-06" AvgRowSize="48" EstimatedTotalSubtreeCost="574.231" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="globalagg1087"></ColumnReference><ColumnReference Column="globalagg1089"></ColumnReference><ColumnReference Column="globalagg1091"></ColumnReference><ColumnReference Column="globalagg1093"></ColumnReference></OutputList><Move DistributionType="Any" MoveTopology="OneToMany"><RelOp NodeId="63" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0017751" AvgRowSize="48" EstimatedTotalSubtreeCost="574.198" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="globalagg1087"></ColumnReference><ColumnReference Column="globalagg1089"></ColumnReference><ColumnReference Column="globalagg1091"></ColumnReference><ColumnReference Column="globalagg1093"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="globalagg1093"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1092])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1092"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1087"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1097])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1097"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1089"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1098])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1098"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1091"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1099])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1099"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="64" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="2" EstimateIO="0.023125" EstimateCPU="4.2e-06" AvgRowSize="48" EstimatedTotalSubtreeCost="574.196" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="partialagg1092"></ColumnReference><ColumnReference Column="partialagg1097"></ColumnReference><ColumnReference Column="partialagg1098"></ColumnReference><ColumnReference Column="partialagg1099"></ColumnReference></OutputList><Move DistributionType="Gather" MoveTopology="ManyToOne"><RelOp NodeId="65" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="0.00187395" AvgRowSize="48" EstimatedTotalSubtreeCost="574.163" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="partialagg1092"></ColumnReference><ColumnReference Column="partialagg1097"></ColumnReference><ColumnReference Column="partialagg1098"></ColumnReference><ColumnReference Column="partialagg1099"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1092"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([TPCDS_SF100].[dbo].[store_sales].[ss_list_price])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1097"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1086])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1086"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1098"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1088])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1088"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1099"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1090])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1090"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="66" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="19760" EstimateIO="0" EstimateCPU="0.054777" AvgRowSize="45" EstimatedTotalSubtreeCost="574.161" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Column="partialagg1086"></ColumnReference><ColumnReference Column="partialagg1088"></ColumnReference><ColumnReference Column="partialagg1090"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1086"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1094])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1094"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1088"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1095])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1095"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1090"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1096])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1096"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_list_price] = [TPCDS_SF100].[dbo].[store_sales].[ss_list_price]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="67" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="39520" EstimateIO="1.5561" EstimateCPU="0.041496" AvgRowSize="45" EstimatedTotalSubtreeCost="574.107" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Column="partialagg1094"></ColumnReference><ColumnReference Column="partialagg1095"></ColumnReference><ColumnReference Column="partialagg1096"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></DistributionKey><RelOp NodeId="68" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="39520" EstimateIO="0" EstimateCPU="0" AvgRowSize="45" EstimatedTotalSubtreeCost="571.768" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Column="partialagg1094"></ColumnReference><ColumnReference Column="partialagg1095"></ColumnReference><ColumnReference Column="partialagg1096"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1096"></ColumnReference><ScalarOperator ScalarString="[partialagg1094]"><Identifier><ColumnReference Column="partialagg1094"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="69" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="39520" EstimateIO="0" EstimateCPU="2.19931" AvgRowSize="45" EstimatedTotalSubtreeCost="571.768" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Column="partialagg1094"></ColumnReference><ColumnReference Column="partialagg1095"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1094"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([TPCDS_SF100].[dbo].[store_sales].[ss_list_price])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1095"></ColumnReference><ScalarOperator ScalarString="SUM([TPCDS_SF100].[dbo].[store_sales].[ss_list_price])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_list_price] = [TPCDS_SF100].[dbo].[store_sales].[ss_list_price]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="70" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="6.4696e+06" EstimateIO="0" EstimateCPU="418.427" AvgRowSize="12" EstimatedTotalSubtreeCost="569.569" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="71" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="6.4696e+06" EstimatedRowsRead="2.87777e+08" EstimateIO="135.314" EstimateCPU="15.8277" AvgRowSize="26" EstimatedTotalSubtreeCost="151.142" TableCardinality="2.87777e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_wholesale_cost"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_wholesale_cost"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="3" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_quantity]&gt;=(11) AND [TPCDS_SF100].[dbo].[store_sales].[ss_quantity]&lt;=(15)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(11)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(15)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_list_price]&gt;=(75.00) AND [TPCDS_SF100].[dbo].[store_sales].[ss_list_price]&lt;=(85) OR [TPCDS_SF100].[dbo].[store_sales].[ss_coupon_amt]&gt;=(6515.00) AND [TPCDS_SF100].[dbo].[store_sales].[ss_coupon_amt]&lt;=(7515) OR [TPCDS_SF100].[dbo].[store_sales].[ss_wholesale_cost]&gt;=(28.00) AND [TPCDS_SF100].[dbo].[store_sales].[ss_wholesale_cost]&lt;=(48)"><Logical Operation="OR"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(75.00)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(85)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(6515.00)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(7515)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_wholesale_cost"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(28.00)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_wholesale_cost"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(48)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp></Hash></RelOp></ComputeScalar></RelOp></Move></RelOp></Hash></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></Move></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp><RelOp NodeId="72" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="36" EstimatedTotalSubtreeCost="574.207" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1115"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1115"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="74" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="32" EstimatedTotalSubtreeCost="574.207" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1017"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [globalagg1073]=(0) THEN NULL ELSE [globalagg1075]/CONVERT_IMPLICIT(decimal(19,0),[globalagg1073],0) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="globalagg1073"></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="globalagg1075"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="19" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1073"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1018"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[globalagg1077],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1077"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="76" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="44" EstimatedTotalSubtreeCost="574.207" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="globalagg1073"></ColumnReference><ColumnReference Column="globalagg1075"></ColumnReference><ColumnReference Column="globalagg1077"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1019"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[globalagg1079],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1079"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="77" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0017751" AvgRowSize="48" EstimatedTotalSubtreeCost="574.207" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="globalagg1073"></ColumnReference><ColumnReference Column="globalagg1075"></ColumnReference><ColumnReference Column="globalagg1077"></ColumnReference><ColumnReference Column="globalagg1079"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="globalagg1079"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1078])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1078"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1073"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1083])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1083"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1075"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1084])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1084"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1077"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1085])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1085"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="78" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="2" EstimateIO="0.023125" EstimateCPU="4.2e-06" AvgRowSize="48" EstimatedTotalSubtreeCost="574.206" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="partialagg1078"></ColumnReference><ColumnReference Column="partialagg1083"></ColumnReference><ColumnReference Column="partialagg1084"></ColumnReference><ColumnReference Column="partialagg1085"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="79" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="0.00187395" AvgRowSize="48" EstimatedTotalSubtreeCost="574.172" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="partialagg1078"></ColumnReference><ColumnReference Column="partialagg1083"></ColumnReference><ColumnReference Column="partialagg1084"></ColumnReference><ColumnReference Column="partialagg1085"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1078"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([TPCDS_SF100].[dbo].[store_sales].[ss_list_price])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1083"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1072])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1072"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1084"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1074])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1074"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1085"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1076])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1076"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="80" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="19760" EstimateIO="0" EstimateCPU="0.054777" AvgRowSize="45" EstimatedTotalSubtreeCost="574.171" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Column="partialagg1072"></ColumnReference><ColumnReference Column="partialagg1074"></ColumnReference><ColumnReference Column="partialagg1076"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1072"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1080])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1080"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1074"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1081])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1081"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1076"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1082])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1082"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_list_price] = [TPCDS_SF100].[dbo].[store_sales].[ss_list_price]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="81" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="39520" EstimateIO="1.5561" EstimateCPU="0.041496" AvgRowSize="45" EstimatedTotalSubtreeCost="574.116" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Column="partialagg1080"></ColumnReference><ColumnReference Column="partialagg1081"></ColumnReference><ColumnReference Column="partialagg1082"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></DistributionKey><RelOp NodeId="82" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="39520" EstimateIO="0" EstimateCPU="0" AvgRowSize="45" EstimatedTotalSubtreeCost="571.778" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Column="partialagg1080"></ColumnReference><ColumnReference Column="partialagg1081"></ColumnReference><ColumnReference Column="partialagg1082"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1082"></ColumnReference><ScalarOperator ScalarString="[partialagg1080]"><Identifier><ColumnReference Column="partialagg1080"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="83" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="39520" EstimateIO="0" EstimateCPU="2.20859" AvgRowSize="45" EstimatedTotalSubtreeCost="571.778" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Column="partialagg1080"></ColumnReference><ColumnReference Column="partialagg1081"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1080"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([TPCDS_SF100].[dbo].[store_sales].[ss_list_price])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1081"></ColumnReference><ScalarOperator ScalarString="SUM([TPCDS_SF100].[dbo].[store_sales].[ss_list_price])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_list_price] = [TPCDS_SF100].[dbo].[store_sales].[ss_list_price]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="84" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="6.49736e+06" EstimateIO="0" EstimateCPU="418.427" AvgRowSize="12" EstimatedTotalSubtreeCost="569.569" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="85" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="6.49736e+06" EstimatedRowsRead="2.87777e+08" EstimateIO="135.314" EstimateCPU="15.8277" AvgRowSize="26" EstimatedTotalSubtreeCost="151.142" TableCardinality="2.87777e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_wholesale_cost"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_wholesale_cost"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="4" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_quantity]&gt;=(16) AND [TPCDS_SF100].[dbo].[store_sales].[ss_quantity]&lt;=(20)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(16)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(20)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_list_price]&gt;=(39.00) AND [TPCDS_SF100].[dbo].[store_sales].[ss_list_price]&lt;=(49) OR [TPCDS_SF100].[dbo].[store_sales].[ss_coupon_amt]&gt;=(1881.00) AND [TPCDS_SF100].[dbo].[store_sales].[ss_coupon_amt]&lt;=(2881) OR [TPCDS_SF100].[dbo].[store_sales].[ss_wholesale_cost]&gt;=(25.00) AND [TPCDS_SF100].[dbo].[store_sales].[ss_wholesale_cost]&lt;=(45)"><Logical Operation="OR"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(39.00)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(49)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1881.00)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2881)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_wholesale_cost"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(25.00)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_wholesale_cost"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(45)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp></Hash></RelOp></ComputeScalar></RelOp></Move></RelOp></Hash></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp><RelOp NodeId="86" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="36" EstimatedTotalSubtreeCost="574.199" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1027"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference><ColumnReference Column="Expr1029"></ColumnReference><ColumnReference Column="Expr1115"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1115"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="88" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="32" EstimatedTotalSubtreeCost="574.199" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1027"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference><ColumnReference Column="Expr1029"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1027"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [globalagg1045]=(0) THEN NULL ELSE [globalagg1047]/CONVERT_IMPLICIT(decimal(19,0),[globalagg1045],0) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="globalagg1045"></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="globalagg1047"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="19" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1045"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1028"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[globalagg1049],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1049"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="90" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-08" AvgRowSize="44" EstimatedTotalSubtreeCost="574.199" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1029"></ColumnReference><ColumnReference Column="globalagg1045"></ColumnReference><ColumnReference Column="globalagg1047"></ColumnReference><ColumnReference Column="globalagg1049"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1029"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[globalagg1051],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1051"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="91" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0017751" AvgRowSize="48" EstimatedTotalSubtreeCost="574.199" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="globalagg1045"></ColumnReference><ColumnReference Column="globalagg1047"></ColumnReference><ColumnReference Column="globalagg1049"></ColumnReference><ColumnReference Column="globalagg1051"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="globalagg1051"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1050])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1050"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1045"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1055])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1055"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1047"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1056])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1056"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="globalagg1049"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1057])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1057"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="92" PhysicalOp="Broadcast" LogicalOp="Move" EstimateRows="2" EstimateIO="0.023125" EstimateCPU="4.2e-06" AvgRowSize="48" EstimatedTotalSubtreeCost="574.197" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="partialagg1050"></ColumnReference><ColumnReference Column="partialagg1055"></ColumnReference><ColumnReference Column="partialagg1056"></ColumnReference><ColumnReference Column="partialagg1057"></ColumnReference></OutputList><Move DistributionType="Broadcast" MoveTopology="ManyToMany"><RelOp NodeId="93" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="0.00187395" AvgRowSize="48" EstimatedTotalSubtreeCost="574.164" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="partialagg1050"></ColumnReference><ColumnReference Column="partialagg1055"></ColumnReference><ColumnReference Column="partialagg1056"></ColumnReference><ColumnReference Column="partialagg1057"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1050"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([TPCDS_SF100].[dbo].[store_sales].[ss_list_price])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1055"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1044])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1044"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1056"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1046])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1046"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1057"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1048])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1048"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="94" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="19760" EstimateIO="0" EstimateCPU="0.054777" AvgRowSize="45" EstimatedTotalSubtreeCost="574.162" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Column="partialagg1044"></ColumnReference><ColumnReference Column="partialagg1046"></ColumnReference><ColumnReference Column="partialagg1048"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1044"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1052])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1052"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1046"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1053])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1053"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1048"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1054])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1054"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_list_price] = [TPCDS_SF100].[dbo].[store_sales].[ss_list_price]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="95" PhysicalOp="Shuffle" LogicalOp="Move" EstimateRows="39520" EstimateIO="1.5561" EstimateCPU="0.041496" AvgRowSize="45" EstimatedTotalSubtreeCost="574.108" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Column="partialagg1052"></ColumnReference><ColumnReference Column="partialagg1053"></ColumnReference><ColumnReference Column="partialagg1054"></ColumnReference></OutputList><Move DistributionType="Hash" MoveTopology="ManyToMany"><DistributionKey><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></DistributionKey><RelOp NodeId="96" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="39520" EstimateIO="0" EstimateCPU="0" AvgRowSize="45" EstimatedTotalSubtreeCost="571.769" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Column="partialagg1052"></ColumnReference><ColumnReference Column="partialagg1053"></ColumnReference><ColumnReference Column="partialagg1054"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1054"></ColumnReference><ScalarOperator ScalarString="[partialagg1052]"><Identifier><ColumnReference Column="partialagg1052"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="97" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="39520" EstimateIO="0" EstimateCPU="2.20045" AvgRowSize="45" EstimatedTotalSubtreeCost="571.769" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Column="partialagg1052"></ColumnReference><ColumnReference Column="partialagg1053"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="partialagg1052"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([TPCDS_SF100].[dbo].[store_sales].[ss_list_price])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1053"></ColumnReference><ScalarOperator ScalarString="SUM([TPCDS_SF100].[dbo].[store_sales].[ss_list_price])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_list_price] = [TPCDS_SF100].[dbo].[store_sales].[ss_list_price]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="98" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="6.47301e+06" EstimateIO="0" EstimateCPU="418.427" AvgRowSize="12" EstimatedTotalSubtreeCost="569.569" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="99" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="6.47301e+06" EstimatedRowsRead="2.87777e+08" EstimateIO="135.314" EstimateCPU="15.8277" AvgRowSize="26" EstimatedTotalSubtreeCost="151.142" TableCardinality="2.87777e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_wholesale_cost"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_wholesale_cost"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" TableReferenceId="6" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_quantity]&gt;=(26) AND [TPCDS_SF100].[dbo].[store_sales].[ss_quantity]&lt;=(30)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(26)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_quantity"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(30)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_list_price]&gt;=(24.00) AND [TPCDS_SF100].[dbo].[store_sales].[ss_list_price]&lt;=(34) OR [TPCDS_SF100].[dbo].[store_sales].[ss_coupon_amt]&gt;=(5272.00) AND [TPCDS_SF100].[dbo].[store_sales].[ss_coupon_amt]&lt;=(6272) OR [TPCDS_SF100].[dbo].[store_sales].[ss_wholesale_cost]&gt;=(30.00) AND [TPCDS_SF100].[dbo].[store_sales].[ss_wholesale_cost]&lt;=(50)"><Logical Operation="OR"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(24.00)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_list_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(34)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(5272.00)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_coupon_amt"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(6272)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_wholesale_cost"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(30.00)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_wholesale_cost"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(50)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp></Hash></RelOp></ComputeScalar></RelOp></Move></RelOp></Hash></RelOp></Hash></RelOp></Move></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></Top></RelOp></Move></RelOp></Top></RelOp></Move></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
