<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.612" Build="18.0.277.116"><BatchSequence><Batch><Statements><StmtSimple StatementText="WITH ss AS (&#xa;  SELECT&#xa;    s_store_sk AS s_store_sk,&#xa;    SUM(ss_ext_sales_price) AS sales,&#xa;    SUM(ss_net_profit) AS profit&#xa;  FROM store_sales, date_dim, store&#xa;  WHERE&#xa;    ss_sold_date_sk = d_date_sk&#xa;    AND d_date BETWEEN CAST(&apos;2002-08-26&apos; AS DATE) AND (&#xa;      DATEADD(DAY, 30, CAST(&apos;2002-08-26&apos; AS DATE))&#xa;    )&#xa;    AND ss_store_sk = s_store_sk&#xa;  GROUP BY&#xa;    s_store_sk&#xa;), sr AS (&#xa;  SELECT&#xa;    s_store_sk AS s_store_sk,&#xa;    SUM(sr_return_amt) AS returns,&#xa;    SUM(sr_net_loss) AS profit_loss&#xa;  FROM store_returns, date_dim, store&#xa;  WHERE&#xa;    sr_returned_date_sk = d_date_sk&#xa;    AND d_date BETWEEN CAST(&apos;2002-08-26&apos; AS DATE) AND (&#xa;      DATEADD(DAY, 30, CAST(&apos;2002-08-26&apos; AS DATE))&#xa;    )&#xa;    AND sr_store_sk = s_store_sk&#xa;  GROUP BY&#xa;    s_store_sk&#xa;), cs AS (&#xa;  SELECT&#xa;    cs_call_center_sk AS cs_call_center_sk,&#xa;    SUM(cs_ext_sales_price) AS sales,&#xa;    SUM(cs_net_profit) AS profit&#xa;  FROM catalog_sales, date_dim&#xa;  WHERE&#xa;    cs_sold_date_sk = d_date_sk&#xa;    AND d_date BETWEEN CAST(&apos;2002-08-26&apos; AS DATE) AND (&#xa;      DATEADD(DAY, 30, CAST(&apos;2002-08-26&apos; AS DATE))&#xa;    )&#xa;  GROUP BY&#xa;    cs_call_center_sk&#xa;), cr AS (&#xa;  SELECT&#xa;    cr_call_center_sk AS cr_call_center_sk,&#xa;    SUM(cr_return_amount) AS returns,&#xa;    SUM(cr_net_loss) AS profit_loss&#xa;  FROM catalog_returns, date_dim&#xa;  WHERE&#xa;    cr_returned_date_sk = d_date_sk&#xa;    AND d_date BETWEEN CAST(&apos;2002-08-26&apos; AS DATE) AND (&#xa;      DATEADD(DAY, 30, CAST(&apos;2002-08-26&apos; AS DATE))&#xa;    )&#xa;  GROUP BY&#xa;    cr_call_center_sk&#xa;), ws AS (&#xa;  SELECT&#xa;    wp_web_page_sk AS wp_web_page_sk,&#xa;    SUM(ws_ext_sales_price) AS sales,&#xa;    SUM(ws_net_profit) AS profit&#xa;  FROM web_sales, date_dim, web_page&#xa;  WHERE&#xa;    ws_sold_date_sk = d_date_sk&#xa;    AND d_date BETWEEN CAST(&apos;2002-08-26&apos; AS DATE) AND (&#xa;      DATEADD(DAY, 30, CAST(&apos;2002-08-26&apos; AS DATE))&#xa;    )&#xa;    AND ws_web_page_sk = wp_web_page_sk&#xa;  GROUP BY&#xa;    wp_web_page_sk&#xa;), wr AS (&#xa;  SELECT&#xa;    wp_web_page_sk AS wp_web_page_sk,&#xa;    SUM(wr_return_amt) AS returns,&#xa;    SUM(wr_net_loss) AS profit_loss&#xa;  FROM web_returns, date_dim, web_page&#xa;  WHERE&#xa;    wr_returned_date_sk = d_date_sk&#xa;    AND d_date BETWEEN CAST(&apos;2002-08-26&apos; AS DATE) AND (&#xa;      DATEADD(DAY, 30, CAST(&apos;2002-08-26&apos; AS DATE))&#xa;    )&#xa;    AND wr_web_page_sk = wp_web_page_sk&#xa;  GROUP BY&#xa;    wp_web_page_sk&#xa;)&#xa;SELECT&#xa;TOP 100&#xa;  channel,&#xa;  id,&#xa;  SUM(sales) AS sales,&#xa;  SUM(returns) AS returns,&#xa;  SUM(profit) AS profit&#xa;FROM (&#xa;  SELECT&#xa;    &apos;store channel&apos; AS channel,&#xa;    ss.s_store_sk AS id,&#xa;    sales,&#xa;    COALESCE(returns, 0) AS returns,&#xa;    (&#xa;      profit - COALESCE(profit_loss, 0)&#xa;    ) AS profit&#xa;  FROM ss&#xa;  LEFT JOIN sr&#xa;    ON ss.s_store_sk = sr.s_store_sk&#xa;  UNION ALL&#xa;  SELECT&#xa;    &apos;catalog channel&apos; AS channel,&#xa;    cs_call_center_sk AS id,&#xa;    sales,&#xa;    returns,&#xa;    (&#xa;      profit - profit_loss&#xa;    ) AS profit&#xa;  FROM cs, cr&#xa;  UNION ALL&#xa;  SELECT&#xa;    &apos;web channel&apos; AS channel,&#xa;    ws.wp_web_page_sk AS id,&#xa;    sales,&#xa;    COALESCE(returns, 0) AS returns,&#xa;    (&#xa;      profit - COALESCE(profit_loss, 0)&#xa;    ) AS profit&#xa;  FROM ws&#xa;  LEFT JOIN wr&#xa;    ON ws.wp_web_page_sk = wr.wp_web_page_sk&#xa;) AS x&#xa;GROUP BY&#xa;  ROLLUP (&#xa;    channel,&#xa;    id&#xa;  )&#xa;ORDER BY&#xa;  channel,&#xa;  id" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="338.328" StatementEstRows="100" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x4984C89ACC4AB60C" QueryPlanHash="0x9D52E4E982338B17" 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="864" CompileTime="80" CompileCPU="80" CompileMemory="7624"><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:24:02.15" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_7B5B524B]" Table="[store_returns]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:32:27.99" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_02FC7413]" Table="[web_returns]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:42:22.76" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000001_07C12930]" Table="[store]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:35:21.06" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000D_03F0984C]" Table="[web_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:33:57.73" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000C_04E4BC85]" Table="[catalog_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:32:25.98" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_02084FDA]" Table="[catalog_returns]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:02.84" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000008_7B5B524B]" Table="[store_returns]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:04.43" ModificationCount="0" SamplingPercent="73.9837" Statistics="[_WA_Sys_00000001_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:35:21.24" ModificationCount="0" SamplingPercent="99.657" Statistics="[_WA_Sys_00000001_7D439ABD]" Table="[web_page]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:31:25.34" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_03F0984C]" Table="[web_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:42.45" ModificationCount="0" SamplingPercent="73.9544" Statistics="[_WA_Sys_00000003_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:35:21.59" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000C_02FC7413]" Table="[web_returns]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:31:26.42" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_04E4BC85]" Table="[catalog_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:03.26" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_05D8E0BE]" Table="[store_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:14.18" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000008_05D8E0BE]" Table="[store_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:35:20.41" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000C_02084FDA]" Table="[catalog_returns]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="100" EstimateIO="0" EstimateCPU="1e-05" AvgRowSize="73" EstimatedTotalSubtreeCost="338.328" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1058"></ColumnReference><ColumnReference Column="Union1059"></ColumnReference><ColumnReference Column="Expr1063"></ColumnReference><ColumnReference Column="Expr1064"></ColumnReference><ColumnReference Column="Expr1065"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Union1058"></ColumnReference><ScalarOperator ScalarString="[Union1058]"><Identifier><ColumnReference Column="Union1058"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Union1059"></ColumnReference><ScalarOperator ScalarString="[Union1059]"><Identifier><ColumnReference Column="Union1059"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1063"></ColumnReference><ScalarOperator ScalarString="[Expr1063]"><Identifier><ColumnReference Column="Expr1063"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1064"></ColumnReference><ScalarOperator ScalarString="[Expr1064]"><Identifier><ColumnReference Column="Expr1064"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1065"></ColumnReference><ScalarOperator ScalarString="[Expr1065]"><Identifier><ColumnReference Column="Expr1065"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="100" EstimateIO="0" EstimateCPU="1e-05" AvgRowSize="73" EstimatedTotalSubtreeCost="338.328" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1058"></ColumnReference><ColumnReference Column="Union1059"></ColumnReference><ColumnReference Column="Expr1063"></ColumnReference><ColumnReference Column="Expr1064"></ColumnReference><ColumnReference Column="Expr1065"></ColumnReference></OutputList><Move DistributionType="Return" MoveTopology="OneToOne"><RelOp NodeId="3" PhysicalOp="Sort" LogicalOp="TopN Sort" EstimateRows="100" EstimateIO="0.00563063" EstimateCPU="0.00227193" AvgRowSize="73" EstimatedTotalSubtreeCost="338.328" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1058"></ColumnReference><ColumnReference Column="Union1059"></ColumnReference><ColumnReference Column="Expr1063"></ColumnReference><ColumnReference Column="Expr1064"></ColumnReference><ColumnReference Column="Expr1065"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><TopSort Distinct="0" Rows="100"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Column="Union1058"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Union1059"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="5" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="920.863" EstimateIO="0" EstimateCPU="0" AvgRowSize="73" EstimatedTotalSubtreeCost="338.32" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1063"></ColumnReference><ColumnReference Column="Expr1064"></ColumnReference><ColumnReference Column="Expr1065"></ColumnReference><ColumnReference Column="Expr1070"></ColumnReference><ColumnReference Column="Expr1071"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1063"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1135]=(0) THEN NULL ELSE [Expr1136] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1135"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1136"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1064"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1137]=(0) THEN NULL ELSE [Expr1138] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1137"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1138"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1065"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1139]=(0) THEN NULL ELSE [Expr1140] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1139"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1140"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="6" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="920.863" EstimateIO="0" EstimateCPU="0.0122386" AvgRowSize="73" EstimatedTotalSubtreeCost="338.32" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1070"></ColumnReference><ColumnReference Column="Expr1071"></ColumnReference><ColumnReference Column="Expr1135"></ColumnReference><ColumnReference Column="Expr1136"></ColumnReference><ColumnReference Column="Expr1137"></ColumnReference><ColumnReference Column="Expr1138"></ColumnReference><ColumnReference Column="Expr1139"></ColumnReference><ColumnReference Column="Expr1140"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1135"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1067])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1067"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1136"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1067])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1067"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1137"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1068])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1068"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1138"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1068])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1068"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1139"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1069])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1069"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1140"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1069])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1069"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1070"></ColumnReference><ColumnReference Column="Expr1071"></ColumnReference><ColumnReference Column="Expr1066"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[Expr1070] = [Expr1070] AND [Expr1071] = [Expr1071] AND [Expr1066] = [Expr1066]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Expr1070"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1070"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Expr1071"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1071"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Expr1066"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1066"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="8" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="6666.47" EstimateIO="0" EstimateCPU="6.66647e-05" AvgRowSize="77" EstimatedTotalSubtreeCost="338.307" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1066"></ColumnReference><ColumnReference Column="partialagg1067"></ColumnReference><ColumnReference Column="partialagg1068"></ColumnReference><ColumnReference Column="partialagg1069"></ColumnReference><ColumnReference Column="Expr1070"></ColumnReference><ColumnReference Column="Expr1071"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1070"></ColumnReference><ScalarOperator ScalarString="CASE WHEN ([Expr1066]&amp;(1))=(0) THEN [Union1058] ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Arithmetic Operation="BIT_AND"><ScalarOperator><Identifier><ColumnReference Column="Expr1066"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Union1058"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1071"></ColumnReference><ScalarOperator ScalarString="CASE WHEN ([Expr1066]&amp;(2))=(0) THEN [Union1059] ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Arithmetic Operation="BIT_AND"><ScalarOperator><Identifier><ColumnReference Column="Expr1066"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2)"></Const></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Union1059"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="9" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="6666.47" EstimateIO="0" EstimateCPU="0.00338355" AvgRowSize="77" EstimatedTotalSubtreeCost="338.307" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1058"></ColumnReference><ColumnReference Column="Union1059"></ColumnReference><ColumnReference Column="Expr1066"></ColumnReference><ColumnReference Column="partialagg1067"></ColumnReference><ColumnReference Column="partialagg1068"></ColumnReference><ColumnReference Column="partialagg1069"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1093"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Expr1094"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Expr1093]=[Expr1094]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1093"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1094"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="10" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="3" EstimateIO="0" EstimateCPU="3e-08" AvgRowSize="15" EstimatedTotalSubtreeCost="3.793e-06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1066"></ColumnReference><ColumnReference Column="Expr1093"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1093"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="11" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="3" EstimateIO="0" EstimateCPU="3.157e-06" AvgRowSize="11" EstimatedTotalSubtreeCost="3.157e-06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1066"></ColumnReference></OutputList><ConstantScan><Values><Row><ScalarOperator ScalarString="(3)"><Const ConstValue="(3)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(2)"><Const ConstValue="(2)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></Row></Values></ConstantScan></RelOp></ComputeScalar></RelOp><RelOp NodeId="12" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2222.16" EstimateIO="0" EstimateCPU="2.22216e-05" AvgRowSize="77" EstimatedTotalSubtreeCost="338.304" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1058"></ColumnReference><ColumnReference Column="Union1059"></ColumnReference><ColumnReference Column="partialagg1067"></ColumnReference><ColumnReference Column="partialagg1068"></ColumnReference><ColumnReference Column="partialagg1069"></ColumnReference><ColumnReference Column="Expr1094"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1094"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="13" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="2222.16" EstimateIO="0" EstimateCPU="2.26992e-05" AvgRowSize="73" EstimatedTotalSubtreeCost="338.304" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1058"></ColumnReference><ColumnReference Column="Union1059"></ColumnReference><ColumnReference Column="partialagg1067"></ColumnReference><ColumnReference Column="partialagg1068"></ColumnReference><ColumnReference Column="partialagg1069"></ColumnReference></OutputList><Concat><DefinedValues><DefinedValue><ColumnReference Column="partialagg1067"></ColumnReference><ColumnReference Column="partialagg1067"></ColumnReference><ColumnReference Column="partialagg1067"></ColumnReference><ColumnReference Column="partialagg1067"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="partialagg1068"></ColumnReference><ColumnReference Column="partialagg1068"></ColumnReference><ColumnReference Column="partialagg1068"></ColumnReference><ColumnReference Column="partialagg1068"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="partialagg1069"></ColumnReference><ColumnReference Column="partialagg1069"></ColumnReference><ColumnReference Column="partialagg1069"></ColumnReference><ColumnReference Column="partialagg1069"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1058"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1034"></ColumnReference><ColumnReference Column="Expr1055"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1059"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_call_center_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_page]" Column="wp_web_page_sk"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="14" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="201" EstimateIO="0" EstimateCPU="2.01e-06" AvgRowSize="72" EstimatedTotalSubtreeCost="194.673" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="partialagg1067"></ColumnReference><ColumnReference Column="partialagg1068"></ColumnReference><ColumnReference Column="partialagg1069"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1067"></ColumnReference><ScalarOperator ScalarString="[Expr1006]"><Identifier><ColumnReference Column="Expr1006"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1068"></ColumnReference><ScalarOperator ScalarString="[Expr1020]"><Identifier><ColumnReference Column="Expr1020"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1069"></ColumnReference><ScalarOperator ScalarString="[Expr1021]"><Identifier><ColumnReference Column="Expr1021"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="15" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="201" EstimateIO="0" EstimateCPU="2.01e-06" AvgRowSize="72" EstimatedTotalSubtreeCost="194.673" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1019"></ColumnReference><ScalarOperator ScalarString="&apos;store channel&apos;"><Const ConstValue="&apos;store channel&apos;"></Const></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1020"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1014] IS NOT NULL THEN [Expr1014] ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Column="Expr1014"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1014"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1021"></ColumnReference><ScalarOperator ScalarString="[Expr1007]-CASE WHEN [Expr1015] IS NOT NULL THEN [Expr1015] ELSE (0.00) END"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="Expr1007"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Column="Expr1015"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1015"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="16" PhysicalOp="Hash Match" LogicalOp="Right Outer Join" EstimateRows="201" EstimateIO="0" EstimateCPU="0.00241842" AvgRowSize="79" EstimatedTotalSubtreeCost="194.673" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="17" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="201" EstimateIO="0" EstimateCPU="0" AvgRowSize="45" EstimatedTotalSubtreeCost="17.6914" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1014"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1105]=(0) THEN NULL ELSE [Expr1106] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1105"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1106"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1015"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1107]=(0) THEN NULL ELSE [Expr1108] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1107"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1108"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="18" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="201" EstimateIO="0" EstimateCPU="0.206226" AvgRowSize="45" EstimatedTotalSubtreeCost="17.6914" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference><ColumnReference Column="Expr1105"></ColumnReference><ColumnReference Column="Expr1106"></ColumnReference><ColumnReference Column="Expr1107"></ColumnReference><ColumnReference Column="Expr1108"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1105"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([TPCDS_SF100].[dbo].[store_returns].[sr_return_amt])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1106"></ColumnReference><ScalarOperator ScalarString="SUM([TPCDS_SF100].[dbo].[store_returns].[sr_return_amt])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1107"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([TPCDS_SF100].[dbo].[store_returns].[sr_net_loss])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_net_loss"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1108"></ColumnReference><ScalarOperator ScalarString="SUM([TPCDS_SF100].[dbo].[store_returns].[sr_net_loss])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_net_loss"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></HashKeysBuild><RelOp NodeId="19" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="436634" EstimateIO="0" EstimateCPU="0.235373" AvgRowSize="21" EstimatedTotalSubtreeCost="17.4851" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_net_loss"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="20" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="402" EstimatedRowsRead="402" EstimateIO="0.003125" EstimateCPU="5.992e-05" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00318492" TableCardinality="402" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></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]" Column="s_store_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="21" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="436634" EstimateIO="0" EstimateCPU="0.42408" AvgRowSize="21" EstimatedTotalSubtreeCost="17.2465" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_net_loss"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1095"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_returned_date_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_returns].[sr_returned_date_sk]=[TPCDS_SF100].[dbo].[date_dim].[d_date_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_returned_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="22" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="32.4469" EstimatedRowsRead="73239" EstimateIO="0.0209271" EstimateCPU="0.00807199" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0289991" TableCardinality="73239" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_date]&gt;=&apos;2002-08-26&apos; AND [TPCDS_SF100].[dbo].[date_dim].[d_date]&lt;=&apos;2002-09-25&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2002-08-26&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2002-09-25&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="23" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.71966e+07" EstimatedRowsRead="2.86846e+07" EstimateIO="12.971" EstimateCPU="3.15532" AvgRowSize="25" EstimatedTotalSubtreeCost="16.1263" TableCardinality="2.86846e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_returned_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_net_loss"></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_returns]" Column="sr_returned_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_net_loss"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_returns].[sr_returned_date_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_returns].[sr_store_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_returned_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp><RelOp NodeId="24" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="201" EstimateIO="0" EstimateCPU="0" AvgRowSize="45" EstimatedTotalSubtreeCost="176.979" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1006"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1109]=(0) THEN NULL ELSE [Expr1110] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1109"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1110"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1007"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1111]=(0) THEN NULL ELSE [Expr1112] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1111"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1112"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="25" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="201" EstimateIO="0" EstimateCPU="2.21217" AvgRowSize="45" EstimatedTotalSubtreeCost="176.979" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference><ColumnReference Column="Expr1109"></ColumnReference><ColumnReference Column="Expr1110"></ColumnReference><ColumnReference Column="Expr1111"></ColumnReference><ColumnReference Column="Expr1112"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1109"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([TPCDS_SF100].[dbo].[store_sales].[ss_ext_sales_price])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1110"></ColumnReference><ScalarOperator ScalarString="SUM([TPCDS_SF100].[dbo].[store_sales].[ss_ext_sales_price])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1111"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([TPCDS_SF100].[dbo].[store_sales].[ss_net_profit])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_net_profit"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1112"></ColumnReference><ScalarOperator ScalarString="SUM([TPCDS_SF100].[dbo].[store_sales].[ss_net_profit])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_net_profit"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></HashKeysBuild><RelOp NodeId="26" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="4.72742e+06" EstimateIO="0" EstimateCPU="2.52708" AvgRowSize="21" EstimatedTotalSubtreeCost="174.767" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_net_profit"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="27" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="402" EstimatedRowsRead="402" EstimateIO="0.003125" EstimateCPU="5.992e-05" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00318492" TableCardinality="402" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></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]" Column="s_store_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="28" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="4.72742e+06" EstimateIO="0" EstimateCPU="4.20523" AvgRowSize="21" EstimatedTotalSubtreeCost="172.237" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_net_profit"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1097"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_sold_date_sk]=[TPCDS_SF100].[dbo].[date_dim].[d_date_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="29" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="32.4469" EstimatedRowsRead="73239" EstimateIO="0.0209271" EstimateCPU="0.00807199" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0289991" TableCardinality="73239" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_date]&gt;=&apos;2002-08-26&apos; AND [TPCDS_SF100].[dbo].[date_dim].[d_date]&lt;=&apos;2002-09-25&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2002-08-26&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2002-09-25&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="30" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.68681e+08" EstimatedRowsRead="2.87777e+08" EstimateIO="130.11" EstimateCPU="31.6554" AvgRowSize="25" EstimatedTotalSubtreeCost="161.765" TableCardinality="2.87777e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_net_profit"></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_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_net_profit"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[store_sales].[ss_sold_date_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[store_sales].[ss_store_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp><RelOp NodeId="31" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="31" EstimateIO="0" EstimateCPU="0" AvgRowSize="73" EstimatedTotalSubtreeCost="94.7809" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_call_center_sk"></ColumnReference><ColumnReference Column="Expr1034"></ColumnReference><ColumnReference Column="partialagg1067"></ColumnReference><ColumnReference Column="partialagg1068"></ColumnReference><ColumnReference Column="partialagg1069"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1067"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1121]=(0) THEN NULL ELSE [Expr1122] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1121"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1122"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1068"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1123]=(0) THEN NULL ELSE [Expr1124] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1123"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1124"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1069"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1125]=(0) THEN NULL ELSE [Expr1126] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1125"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1126"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="32" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="31" EstimateIO="0" EstimateCPU="0.00259659" AvgRowSize="73" EstimatedTotalSubtreeCost="94.7809" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_call_center_sk"></ColumnReference><ColumnReference Column="Expr1034"></ColumnReference><ColumnReference Column="Expr1121"></ColumnReference><ColumnReference Column="Expr1122"></ColumnReference><ColumnReference Column="Expr1123"></ColumnReference><ColumnReference Column="Expr1124"></ColumnReference><ColumnReference Column="Expr1125"></ColumnReference><ColumnReference Column="Expr1126"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1121"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1026])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1026"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1122"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1026])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1026"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1123"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1032])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1032"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1124"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1032])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1032"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1125"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1035])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1035"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1126"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1035])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1035"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1034"></ColumnReference><ScalarOperator ScalarString="ANY([Expr1034])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1034"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_call_center_sk"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[catalog_sales].[cs_call_center_sk] = [TPCDS_SF100].[dbo].[catalog_sales].[cs_call_center_sk]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_call_center_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_call_center_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="33" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="961" EstimateIO="0" EstimateCPU="9.61e-06" AvgRowSize="73" EstimatedTotalSubtreeCost="94.7783" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_call_center_sk"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1032"></ColumnReference><ColumnReference Column="Expr1034"></ColumnReference><ColumnReference Column="Expr1035"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1034"></ColumnReference><ScalarOperator ScalarString="&apos;catalog channel&apos;"><Const ConstValue="&apos;catalog channel&apos;"></Const></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1035"></ColumnReference><ScalarOperator ScalarString="[Expr1027]-[Expr1033]"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="Expr1027"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1033"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="34" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="961" EstimateIO="0" EstimateCPU="0.00196175" AvgRowSize="79" EstimatedTotalSubtreeCost="94.7783" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_call_center_sk"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference><ColumnReference Column="Expr1032"></ColumnReference><ColumnReference Column="Expr1033"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1093"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Expr1094"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Expr1093]=[Expr1094]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1093"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1094"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="35" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="31" EstimateIO="0" EstimateCPU="3.1e-07" AvgRowSize="45" EstimatedTotalSubtreeCost="8.68179" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1032"></ColumnReference><ColumnReference Column="Expr1033"></ColumnReference><ColumnReference Column="Expr1093"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1093"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="36" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="31" EstimateIO="0" EstimateCPU="0" AvgRowSize="41" EstimatedTotalSubtreeCost="8.68179" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1032"></ColumnReference><ColumnReference Column="Expr1033"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1032"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1113]=(0) THEN NULL ELSE [Expr1114] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1113"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1114"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1033"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1115]=(0) THEN NULL ELSE [Expr1116] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1115"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1116"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="37" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="31" EstimateIO="0" EstimateCPU="0.154026" AvgRowSize="41" EstimatedTotalSubtreeCost="8.68179" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1113"></ColumnReference><ColumnReference Column="Expr1114"></ColumnReference><ColumnReference Column="Expr1115"></ColumnReference><ColumnReference Column="Expr1116"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1113"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([TPCDS_SF100].[dbo].[catalog_returns].[cr_return_amount])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_amount"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1114"></ColumnReference><ScalarOperator ScalarString="SUM([TPCDS_SF100].[dbo].[catalog_returns].[cr_return_amount])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_amount"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1115"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([TPCDS_SF100].[dbo].[catalog_returns].[cr_net_loss])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_net_loss"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1116"></ColumnReference><ScalarOperator ScalarString="SUM([TPCDS_SF100].[dbo].[catalog_returns].[cr_net_loss])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_net_loss"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_call_center_sk"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[catalog_returns].[cr_call_center_sk] = [TPCDS_SF100].[dbo].[catalog_returns].[cr_call_center_sk]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_call_center_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_call_center_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="38" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="227862" EstimateIO="0" EstimateCPU="0.225498" AvgRowSize="21" EstimatedTotalSubtreeCost="8.52776" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_call_center_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_amount"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_net_loss"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1099"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_returned_date_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[catalog_returns].[cr_returned_date_sk]=[TPCDS_SF100].[dbo].[date_dim].[d_date_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_returned_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="39" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="32.4469" EstimatedRowsRead="73239" EstimateIO="0.0209271" EstimateCPU="0.00807199" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0289991" TableCardinality="73239" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="4" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_date]&gt;=&apos;2002-08-26&apos; AND [TPCDS_SF100].[dbo].[date_dim].[d_date]&lt;=&apos;2002-09-25&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2002-08-26&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2002-09-25&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="40" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.44253e+07" EstimatedRowsRead="1.44253e+07" EstimateIO="6.52425" EstimateCPU="1.5868" AvgRowSize="25" EstimatedTotalSubtreeCost="8.11105" TableCardinality="1.44253e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_returned_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_call_center_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_amount"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_net_loss"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_returned_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_call_center_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_amount"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_net_loss"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[catalog_returns].[cr_returned_date_sk] IS NOT NULL"><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_returned_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp><RelOp NodeId="41" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="31" EstimateIO="0" EstimateCPU="3.1e-07" AvgRowSize="49" EstimatedTotalSubtreeCost="86.0945" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_call_center_sk"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference><ColumnReference Column="Expr1094"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1094"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="42" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="31" EstimateIO="0" EstimateCPU="0" AvgRowSize="45" EstimatedTotalSubtreeCost="86.0945" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_call_center_sk"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1026"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1117]=(0) THEN NULL ELSE [Expr1118] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1117"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1118"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1027"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1119]=(0) THEN NULL ELSE [Expr1120] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1119"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1120"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="43" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="31" EstimateIO="0" EstimateCPU="1.67408" AvgRowSize="45" EstimatedTotalSubtreeCost="86.0945" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_call_center_sk"></ColumnReference><ColumnReference Column="Expr1117"></ColumnReference><ColumnReference Column="Expr1118"></ColumnReference><ColumnReference Column="Expr1119"></ColumnReference><ColumnReference Column="Expr1120"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1117"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([TPCDS_SF100].[dbo].[catalog_sales].[cs_ext_sales_price])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1118"></ColumnReference><ScalarOperator ScalarString="SUM([TPCDS_SF100].[dbo].[catalog_sales].[cs_ext_sales_price])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1119"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([TPCDS_SF100].[dbo].[catalog_sales].[cs_net_profit])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_profit"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1120"></ColumnReference><ScalarOperator ScalarString="SUM([TPCDS_SF100].[dbo].[catalog_sales].[cs_net_profit])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_profit"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_call_center_sk"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[catalog_sales].[cs_call_center_sk] = [TPCDS_SF100].[dbo].[catalog_sales].[cs_call_center_sk]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_call_center_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_call_center_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="44" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.50387e+06" EstimateIO="0" EstimateCPU="2.24272" AvgRowSize="21" EstimatedTotalSubtreeCost="84.4204" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_call_center_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_profit"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1100"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[catalog_sales].[cs_sold_date_sk]=[TPCDS_SF100].[dbo].[date_dim].[d_date_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="45" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="32.4469" EstimatedRowsRead="73239" EstimateIO="0.0209271" EstimateCPU="0.00807199" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0289991" TableCardinality="73239" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="3" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_date]&gt;=&apos;2002-08-26&apos; AND [TPCDS_SF100].[dbo].[date_dim].[d_date]&lt;=&apos;2002-09-25&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2002-08-26&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2002-09-25&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="46" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.43326e+08" EstimatedRowsRead="1.44063e+08" EstimateIO="65.1349" EstimateCPU="15.8469" AvgRowSize="25" EstimatedTotalSubtreeCost="80.9818" TableCardinality="1.44063e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_call_center_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_profit"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_call_center_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_profit"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[catalog_sales].[cs_sold_date_sk] IS NOT NULL"><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp><RelOp NodeId="47" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2037.92" EstimateIO="0" EstimateCPU="2.03792e-05" AvgRowSize="71" EstimatedTotalSubtreeCost="48.8498" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_page]" Column="wp_web_page_sk"></ColumnReference><ColumnReference Column="Expr1055"></ColumnReference><ColumnReference Column="partialagg1067"></ColumnReference><ColumnReference Column="partialagg1068"></ColumnReference><ColumnReference Column="partialagg1069"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1067"></ColumnReference><ScalarOperator ScalarString="[Expr1042]"><Identifier><ColumnReference Column="Expr1042"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1068"></ColumnReference><ScalarOperator ScalarString="[Expr1056]"><Identifier><ColumnReference Column="Expr1056"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1069"></ColumnReference><ScalarOperator ScalarString="[Expr1057]"><Identifier><ColumnReference Column="Expr1057"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="48" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2037.92" EstimateIO="0" EstimateCPU="2.03792e-05" AvgRowSize="71" EstimatedTotalSubtreeCost="48.8498" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_page]" Column="wp_web_page_sk"></ColumnReference><ColumnReference Column="Expr1042"></ColumnReference><ColumnReference Column="Expr1055"></ColumnReference><ColumnReference Column="Expr1056"></ColumnReference><ColumnReference Column="Expr1057"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1055"></ColumnReference><ScalarOperator ScalarString="&apos;web channel&apos;"><Const ConstValue="&apos;web channel&apos;"></Const></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1056"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1050] IS NOT NULL THEN [Expr1050] ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Column="Expr1050"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1050"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1057"></ColumnReference><ScalarOperator ScalarString="[Expr1043]-CASE WHEN [Expr1051] IS NOT NULL THEN [Expr1051] ELSE (0.00) END"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="Expr1043"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Column="Expr1051"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1051"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="49" PhysicalOp="Hash Match" LogicalOp="Right Outer Join" EstimateRows="2037.92" EstimateIO="0" EstimateCPU="0.0082986" AvgRowSize="79" EstimatedTotalSubtreeCost="48.8497" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_page]" Column="wp_web_page_sk"></ColumnReference><ColumnReference Column="Expr1042"></ColumnReference><ColumnReference Column="Expr1043"></ColumnReference><ColumnReference Column="Expr1050"></ColumnReference><ColumnReference Column="Expr1051"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_page]" Column="wp_web_page_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_page]" Column="wp_web_page_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="50" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2037.92" EstimateIO="0" EstimateCPU="0" AvgRowSize="45" EstimatedTotalSubtreeCost="4.37633" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_page]" Column="wp_web_page_sk"></ColumnReference><ColumnReference Column="Expr1050"></ColumnReference><ColumnReference Column="Expr1051"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1050"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1127]=(0) THEN NULL ELSE [Expr1128] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1127"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1128"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1051"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1129]=(0) THEN NULL ELSE [Expr1130] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1129"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1130"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="51" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2037.92" EstimateIO="0" EstimateCPU="0.0529291" AvgRowSize="45" EstimatedTotalSubtreeCost="4.37633" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_page]" Column="wp_web_page_sk"></ColumnReference><ColumnReference Column="Expr1127"></ColumnReference><ColumnReference Column="Expr1128"></ColumnReference><ColumnReference Column="Expr1129"></ColumnReference><ColumnReference Column="Expr1130"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1127"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([TPCDS_SF100].[dbo].[web_returns].[wr_return_amt])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1128"></ColumnReference><ScalarOperator ScalarString="SUM([TPCDS_SF100].[dbo].[web_returns].[wr_return_amt])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1129"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([TPCDS_SF100].[dbo].[web_returns].[wr_net_loss])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_net_loss"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1130"></ColumnReference><ScalarOperator ScalarString="SUM([TPCDS_SF100].[dbo].[web_returns].[wr_net_loss])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_net_loss"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_page]" Column="wp_web_page_sk"></ColumnReference></HashKeysBuild><RelOp NodeId="52" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="102378" EstimateIO="0" EstimateCPU="0.0584018" AvgRowSize="21" EstimatedTotalSubtreeCost="4.3234" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_net_loss"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_page]" Column="wp_web_page_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_page]" Column="wp_web_page_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_web_page_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="53" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2042" EstimatedRowsRead="2042" EstimateIO="0.003125" EstimateCPU="0.00024032" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00336532" TableCardinality="2042" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_page]" Column="wp_web_page_sk"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_page]" Column="wp_web_page_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_page]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="54" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="102277" EstimateIO="0" EstimateCPU="0.0576641" AvgRowSize="21" EstimatedTotalSubtreeCost="4.26161" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_web_page_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_net_loss"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1101"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returned_date_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[web_returns].[wr_returned_date_sk]=[TPCDS_SF100].[dbo].[date_dim].[d_date_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returned_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="55" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="32.4469" EstimatedRowsRead="73239" EstimateIO="0.0209271" EstimateCPU="0.00807199" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0289991" TableCardinality="73239" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="6" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_date]&gt;=&apos;2002-08-26&apos; AND [TPCDS_SF100].[dbo].[date_dim].[d_date]&lt;=&apos;2002-09-25&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2002-08-26&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2002-09-25&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="56" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="6.71798e+06" EstimatedRowsRead="7.19569e+06" EstimateIO="3.25564" EstimateCPU="0.791542" AvgRowSize="25" EstimatedTotalSubtreeCost="4.04719" TableCardinality="7.19569e+06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returned_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_web_page_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_net_loss"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returned_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_web_page_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_net_loss"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[web_returns].[wr_returned_date_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[web_returns].[wr_web_page_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_returned_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_web_page_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp><RelOp NodeId="57" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2037.92" EstimateIO="0" EstimateCPU="0" AvgRowSize="45" EstimatedTotalSubtreeCost="44.4651" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_page]" Column="wp_web_page_sk"></ColumnReference><ColumnReference Column="Expr1042"></ColumnReference><ColumnReference Column="Expr1043"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1042"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1131]=(0) THEN NULL ELSE [Expr1132] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1131"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1132"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1043"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1133]=(0) THEN NULL ELSE [Expr1134] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1133"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1134"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="58" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2037.92" EstimateIO="0" EstimateCPU="0.597057" AvgRowSize="45" EstimatedTotalSubtreeCost="44.4651" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_page]" Column="wp_web_page_sk"></ColumnReference><ColumnReference Column="Expr1131"></ColumnReference><ColumnReference Column="Expr1132"></ColumnReference><ColumnReference Column="Expr1133"></ColumnReference><ColumnReference Column="Expr1134"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1131"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([TPCDS_SF100].[dbo].[web_sales].[ws_ext_sales_price])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1132"></ColumnReference><ScalarOperator ScalarString="SUM([TPCDS_SF100].[dbo].[web_sales].[ws_ext_sales_price])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1133"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([TPCDS_SF100].[dbo].[web_sales].[ws_net_profit])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_profit"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1134"></ColumnReference><ScalarOperator ScalarString="SUM([TPCDS_SF100].[dbo].[web_sales].[ws_net_profit])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_profit"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_page]" Column="wp_web_page_sk"></ColumnReference></HashKeysBuild><RelOp NodeId="59" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.26629e+06" EstimateIO="0" EstimateCPU="0.679544" AvgRowSize="21" EstimatedTotalSubtreeCost="43.868" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_profit"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_page]" Column="wp_web_page_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_page]" Column="wp_web_page_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_web_page_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="60" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2042" EstimatedRowsRead="2042" EstimateIO="0.003125" EstimateCPU="0.00024032" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00336532" TableCardinality="2042" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_page]" Column="wp_web_page_sk"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_page]" Column="wp_web_page_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_page]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="61" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.26505e+06" EstimateIO="0" EstimateCPU="1.12663" AvgRowSize="21" EstimatedTotalSubtreeCost="43.1851" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_web_page_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_profit"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1103"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[web_sales].[ws_sold_date_sk]=[TPCDS_SF100].[dbo].[date_dim].[d_date_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="62" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="32.4469" EstimatedRowsRead="73239" EstimateIO="0.0209271" EstimateCPU="0.00807199" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0289991" TableCardinality="73239" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="5" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_date]&gt;=&apos;2002-08-26&apos; AND [TPCDS_SF100].[dbo].[date_dim].[d_date]&lt;=&apos;2002-09-25&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2002-08-26&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2002-09-25&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="63" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7.18985e+07" EstimatedRowsRead="7.19256e+07" EstimateIO="32.5208" EstimateCPU="7.91183" AvgRowSize="25" EstimatedTotalSubtreeCost="40.4327" TableCardinality="7.19256e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_web_page_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_profit"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_web_page_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_profit"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[web_sales].[ws_sold_date_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[web_sales].[ws_web_page_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_web_page_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></Concat></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></TopSort></RelOp></Move></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
