<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.612" Build="18.0.277.116"><BatchSequence><Batch><Statements><StmtSimple StatementText="&#xa;with ssr as&#xa; (select  s_store_id as store_id,&#xa;          sum(ss_ext_sales_price) as sales,&#xa;          sum(coalesce(sr_return_amt, 0)) as returns,&#xa;          sum(ss_net_profit - coalesce(sr_net_loss, 0)) as profit&#xa;  from store_sales left outer join store_returns on&#xa;         (ss_item_sk = sr_item_sk and ss_ticket_number = sr_ticket_number),&#xa;     date_dim,&#xa;     store,&#xa;     item,&#xa;     promotion&#xa; where ss_sold_date_sk = d_date_sk&#xa;       and d_date between cast(&apos;2000-06-06&apos; as date)&#xa;                  and dateadd(day, 30, cast(&apos;2000-06-06&apos; as date))&#xa;       and ss_store_sk = s_store_sk&#xa;       and ss_item_sk = i_item_sk&#xa;       and i_current_price &gt; 50&#xa;       and ss_promo_sk = p_promo_sk&#xa;       and p_channel_email = &apos;Y&apos;&#xa;       and p_channel_tv = &apos;Y&apos;&#xa;       and p_channel_radio = &apos;Y&apos;&#xa;       and p_channel_press = &apos;N&apos;&#xa;       and p_channel_event = &apos;N&apos;&#xa;       and ss_wholesale_cost BETWEEN 85 AND 100&#xa;       and i_category IN (&apos;Electronics&apos;, &apos;Home&apos;)&#xa; group by s_store_id)&#xa; ,&#xa; csr as&#xa; (select  cp_catalog_page_id as catalog_page_id,&#xa;          sum(cs_ext_sales_price) as sales,&#xa;          sum(coalesce(cr_return_amount, 0)) as returns,&#xa;          sum(cs_net_profit - coalesce(cr_net_loss, 0)) as profit&#xa;  from catalog_sales left outer join catalog_returns on&#xa;         (cs_item_sk = cr_item_sk and cs_order_number = cr_order_number),&#xa;     date_dim,&#xa;     catalog_page,&#xa;     item,&#xa;     promotion&#xa; where cs_sold_date_sk = d_date_sk&#xa;       and d_date between cast(&apos;2000-06-06&apos; as date)&#xa;                  and dateadd(day, 30, cast(&apos;2000-06-06&apos; as date))&#xa;        and cs_catalog_page_sk = cp_catalog_page_sk&#xa;       and cs_item_sk = i_item_sk&#xa;       and i_current_price &gt; 50&#xa;       and cs_promo_sk = p_promo_sk&#xa;       and p_channel_email = &apos;Y&apos;&#xa;       and p_channel_tv = &apos;Y&apos;&#xa;       and p_channel_radio = &apos;Y&apos;&#xa;       and p_channel_press = &apos;N&apos;&#xa;       and p_channel_event = &apos;N&apos;&#xa;       and cs_wholesale_cost BETWEEN 85 AND 100&#xa;       and i_category IN (&apos;Electronics&apos;, &apos;Home&apos;)&#xa;group by cp_catalog_page_id)&#xa; ,&#xa; wsr as&#xa; (select  web_site_id,&#xa;          sum(ws_ext_sales_price) as sales,&#xa;          sum(coalesce(wr_return_amt, 0)) as returns,&#xa;          sum(ws_net_profit - coalesce(wr_net_loss, 0)) as profit&#xa;  from web_sales left outer join web_returns on&#xa;         (ws_item_sk = wr_item_sk and ws_order_number = wr_order_number),&#xa;     date_dim,&#xa;     web_site,&#xa;     item,&#xa;     promotion&#xa; where ws_sold_date_sk = d_date_sk&#xa;       and d_date between cast(&apos;2000-06-06&apos; as date)&#xa;                  and dateadd(day, 30, cast(&apos;2000-06-06&apos; as date))&#xa;        and ws_web_site_sk = web_site_sk&#xa;       and ws_item_sk = i_item_sk&#xa;       and i_current_price &gt; 50&#xa;       and ws_promo_sk = p_promo_sk&#xa;       and p_channel_email = &apos;Y&apos;&#xa;       and p_channel_tv = &apos;Y&apos;&#xa;       and p_channel_radio = &apos;Y&apos;&#xa;       and p_channel_press = &apos;N&apos;&#xa;       and p_channel_event = &apos;N&apos;&#xa;       and ws_wholesale_cost BETWEEN 85 AND 100&#xa;       and i_category IN (&apos;Electronics&apos;, &apos;Home&apos;)&#xa;group by web_site_id)&#xa;  select top 100 channel&#xa;        , id&#xa;        , sum(sales) as sales&#xa;        , sum(returns) as returns&#xa;        , sum(profit) as profit&#xa; from&#xa; (select &apos;store channel&apos; as channel&#xa;        , &apos;store&apos; + store_id as id&#xa;        , sales&#xa;        , returns&#xa;        , profit&#xa; from   ssr&#xa; union all&#xa; select &apos;catalog channel&apos; as channel&#xa;        , &apos;catalog_page&apos; + catalog_page_id as id&#xa;        , sales&#xa;        , returns&#xa;        , profit&#xa; from  csr&#xa; union all&#xa; select &apos;web channel&apos; as channel&#xa;        , &apos;web_site&apos; + web_site_id as id&#xa;        , sales&#xa;        , returns&#xa;        , profit&#xa; from   wsr&#xa; ) x&#xa; group by rollup (channel, id)&#xa; order by channel&#xa;         ,id" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="502.456" StatementEstRows="100" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x49EFD0B387FD1D13" QueryPlanHash="0x596EC12F8247F9EE" 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="1056" CompileTime="145" CompileCPU="145" CompileMemory="16328"><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-03T18:32:08.42" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_03F0984C]" Table="[catalog_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:33:26.03" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000002_778AC167]" Table="[store]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:34:41.70" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_0000000D_7E37BEF6]" Table="[promotion]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:31:52.89" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000001_778AC167]" Table="[store]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:33:39.54" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000003_02084FDA]" Table="[web_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:34:18" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000011_01142BA1]" Table="[catalog_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:07.30" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000004_02FC7413]" Table="[web_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:34:17.47" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000003_01142BA1]" Table="[catalog_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:47.34" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000014_02FC7413]" Table="[web_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:31:52.51" ModificationCount="0" SamplingPercent="73.9071" Statistics="[_WA_Sys_00000001_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:33:11.64" ModificationCount="0" SamplingPercent="73.9601" Statistics="[_WA_Sys_00000003_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:34:41.53" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000009_04E4BC85]" Table="[store_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:45.64" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000C_04E4BC85]" Table="[store_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:35:20.72" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000002_7A672E12]" Table="[web_site]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:35:19.04" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000D_03F0984C]" Table="[catalog_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:10.82" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000010_03F0984C]" Table="[catalog_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:58:23.14" ModificationCount="0" SamplingPercent="26.8164" Statistics="[_WA_Sys_00000006_76969D2E]" Table="[item]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:39.07" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000008_04E4BC85]" Table="[store_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:34:42.06" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000001_7E37BEF6]" Table="[promotion]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:35:04.50" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000011_03F0984C]" Table="[catalog_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:57:55.49" ModificationCount="0" SamplingPercent="26.4701" Statistics="[_WA_Sys_00000001_76969D2E]" Table="[item]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:05.14" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000003_04E4BC85]" Table="[store_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:35:10.23" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000012_02FC7413]" Table="[web_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:02.95" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_04E4BC85]" Table="[store_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:58:33.40" ModificationCount="0" SamplingPercent="92.9965" Statistics="[_WA_Sys_00000002_7F2BE32F]" Table="[catalog_page]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:35:17.88" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_0000000F_7E37BEF6]" Table="[promotion]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:34:41.93" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_0000000C_7E37BEF6]" Table="[promotion]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:33:25.89" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000A_7B5B524B]" Table="[store_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:34:41.82" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_0000000A_7E37BEF6]" Table="[promotion]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:46.67" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000014_03F0984C]" Table="[catalog_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:57:50.25" ModificationCount="0" SamplingPercent="26.6265" Statistics="[_WA_Sys_0000000D_76969D2E]" Table="[item]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:35:19.79" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000011_02FC7413]" Table="[web_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:32:06.56" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_02FC7413]" Table="[web_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:33:25.12" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000003_7B5B524B]" Table="[store_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:35:20.59" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000001_7A672E12]" Table="[web_site]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:34:17.04" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000012_03F0984C]" Table="[catalog_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:35:10.63" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000E_02084FDA]" Table="[web_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:58:33.18" ModificationCount="0" SamplingPercent="92.9919" Statistics="[_WA_Sys_00000001_7F2BE32F]" Table="[catalog_page]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:35:18.02" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_0000000E_7E37BEF6]" Table="[promotion]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:33:24.43" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000A_04E4BC85]" Table="[store_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:35:20.41" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000E_02FC7413]" Table="[web_sales]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="100" EstimateIO="0" EstimateCPU="1e-05" AvgRowSize="85" EstimatedTotalSubtreeCost="502.456" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1051"></ColumnReference><ColumnReference Column="Union1052"></ColumnReference><ColumnReference Column="Expr1056"></ColumnReference><ColumnReference Column="Expr1057"></ColumnReference><ColumnReference Column="Expr1058"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Union1051"></ColumnReference><ScalarOperator ScalarString="[Union1051]"><Identifier><ColumnReference Column="Union1051"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Union1052"></ColumnReference><ScalarOperator ScalarString="[Union1052]"><Identifier><ColumnReference Column="Union1052"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1056"></ColumnReference><ScalarOperator ScalarString="[Expr1056]"><Identifier><ColumnReference Column="Expr1056"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1057"></ColumnReference><ScalarOperator ScalarString="[Expr1057]"><Identifier><ColumnReference Column="Expr1057"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1058"></ColumnReference><ScalarOperator ScalarString="[Expr1058]"><Identifier><ColumnReference Column="Expr1058"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="100" EstimateIO="0" EstimateCPU="1e-05" AvgRowSize="85" EstimatedTotalSubtreeCost="502.456" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1051"></ColumnReference><ColumnReference Column="Union1052"></ColumnReference><ColumnReference Column="Expr1056"></ColumnReference><ColumnReference Column="Expr1057"></ColumnReference><ColumnReference Column="Expr1058"></ColumnReference></OutputList><Move DistributionType="Return" MoveTopology="OneToOne"><RelOp NodeId="3" PhysicalOp="Sort" LogicalOp="TopN Sort" EstimateRows="100" EstimateIO="0.00563063" EstimateCPU="0.00622405" AvgRowSize="85" EstimatedTotalSubtreeCost="502.456" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1051"></ColumnReference><ColumnReference Column="Union1052"></ColumnReference><ColumnReference Column="Expr1056"></ColumnReference><ColumnReference Column="Expr1057"></ColumnReference><ColumnReference Column="Expr1058"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><TopSort Distinct="0" Rows="100"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Column="Union1051"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Union1052"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="5" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2321.55" EstimateIO="0" EstimateCPU="0" AvgRowSize="85" EstimatedTotalSubtreeCost="502.444" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1056"></ColumnReference><ColumnReference Column="Expr1057"></ColumnReference><ColumnReference Column="Expr1058"></ColumnReference><ColumnReference Column="Expr1063"></ColumnReference><ColumnReference Column="Expr1064"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1056"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1186]=(0) THEN NULL ELSE [Expr1187] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1186"></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="Expr1187"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1057"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1188]=(0) THEN NULL ELSE [Expr1189] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1188"></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="Expr1189"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1058"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1190]=(0) THEN NULL ELSE [Expr1191] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1190"></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="Expr1191"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="6" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2321.55" EstimateIO="0" EstimateCPU="0.0233159" AvgRowSize="85" EstimatedTotalSubtreeCost="502.444" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1063"></ColumnReference><ColumnReference Column="Expr1064"></ColumnReference><ColumnReference Column="Expr1186"></ColumnReference><ColumnReference Column="Expr1187"></ColumnReference><ColumnReference Column="Expr1188"></ColumnReference><ColumnReference Column="Expr1189"></ColumnReference><ColumnReference Column="Expr1190"></ColumnReference><ColumnReference Column="Expr1191"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1186"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1060])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1060"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1187"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1060])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1060"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1188"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1061])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1061"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1189"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1061])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1061"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1190"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([partialagg1062])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="partialagg1062"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1191"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1062])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1062"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1063"></ColumnReference><ColumnReference Column="Expr1064"></ColumnReference><ColumnReference Column="Expr1059"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[Expr1063] = [Expr1063] AND [Expr1064] = [Expr1064] AND [Expr1059] = [Expr1059]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Expr1063"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1063"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Expr1064"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1064"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Expr1059"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1059"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="8" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="6760.98" EstimateIO="0" EstimateCPU="6.76098e-05" AvgRowSize="89" EstimatedTotalSubtreeCost="502.421" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1059"></ColumnReference><ColumnReference Column="partialagg1060"></ColumnReference><ColumnReference Column="partialagg1061"></ColumnReference><ColumnReference Column="partialagg1062"></ColumnReference><ColumnReference Column="Expr1063"></ColumnReference><ColumnReference Column="Expr1064"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1063"></ColumnReference><ScalarOperator ScalarString="CASE WHEN ([Expr1059]&amp;(1))=(0) THEN [Union1051] ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Arithmetic Operation="BIT_AND"><ScalarOperator><Identifier><ColumnReference Column="Expr1059"></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="Union1051"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1064"></ColumnReference><ScalarOperator ScalarString="CASE WHEN ([Expr1059]&amp;(2))=(0) THEN [Union1052] ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Arithmetic Operation="BIT_AND"><ScalarOperator><Identifier><ColumnReference Column="Expr1059"></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="Union1052"></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="6760.98" EstimateIO="0" EstimateCPU="0.00340631" AvgRowSize="102" EstimatedTotalSubtreeCost="502.421" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1051"></ColumnReference><ColumnReference Column="Union1052"></ColumnReference><ColumnReference Column="Expr1059"></ColumnReference><ColumnReference Column="partialagg1060"></ColumnReference><ColumnReference Column="partialagg1061"></ColumnReference><ColumnReference Column="partialagg1062"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Column="Expr1095"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Expr1096"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Expr1095]=[Expr1096]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1095"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1096"></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="Expr1059"></ColumnReference><ColumnReference Column="Expr1095"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1095"></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="Expr1059"></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="2253.66" EstimateIO="0" EstimateCPU="2.25366e-05" AvgRowSize="102" EstimatedTotalSubtreeCost="502.418" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1051"></ColumnReference><ColumnReference Column="Union1052"></ColumnReference><ColumnReference Column="partialagg1060"></ColumnReference><ColumnReference Column="partialagg1061"></ColumnReference><ColumnReference Column="partialagg1062"></ColumnReference><ColumnReference Column="Expr1096"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1096"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="13" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2253.66" EstimateIO="0" EstimateCPU="0" AvgRowSize="98" EstimatedTotalSubtreeCost="502.418" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1051"></ColumnReference><ColumnReference Column="Union1052"></ColumnReference><ColumnReference Column="partialagg1060"></ColumnReference><ColumnReference Column="partialagg1061"></ColumnReference><ColumnReference Column="partialagg1062"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="partialagg1060"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1180]=(0) THEN NULL ELSE [Expr1181] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1180"></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="Expr1181"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1061"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1182]=(0) THEN NULL ELSE [Expr1183] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1182"></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="Expr1183"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="partialagg1062"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1184]=(0) THEN NULL ELSE [Expr1185] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1184"></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="Expr1185"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="14" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2253.66" EstimateIO="0" EstimateCPU="0.0205065" AvgRowSize="98" EstimatedTotalSubtreeCost="502.418" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1051"></ColumnReference><ColumnReference Column="Union1052"></ColumnReference><ColumnReference Column="Expr1180"></ColumnReference><ColumnReference Column="Expr1181"></ColumnReference><ColumnReference Column="Expr1182"></ColumnReference><ColumnReference Column="Expr1183"></ColumnReference><ColumnReference Column="Expr1184"></ColumnReference><ColumnReference Column="Expr1185"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1180"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1053])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1053"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1181"></ColumnReference><ScalarOperator ScalarString="SUM([Union1053])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1053"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1182"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1054])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1054"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1183"></ColumnReference><ScalarOperator ScalarString="SUM([Union1054])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1054"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1184"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1055])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1055"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1185"></ColumnReference><ScalarOperator ScalarString="SUM([Union1055])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1055"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Column="Union1051"></ColumnReference><ColumnReference Column="Union1052"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[Union1051] = [Union1051] AND [Union1052] = [Union1052]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Union1051"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1051"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Union1052"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1052"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="15" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="2263.4" EstimateIO="0" EstimateCPU="2.2634e-05" AvgRowSize="98" EstimatedTotalSubtreeCost="502.397" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1051"></ColumnReference><ColumnReference Column="Union1052"></ColumnReference><ColumnReference Column="Union1053"></ColumnReference><ColumnReference Column="Union1054"></ColumnReference><ColumnReference Column="Union1055"></ColumnReference></OutputList><Concat><DefinedValues><DefinedValue><ColumnReference Column="Union1051"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1032"></ColumnReference><ColumnReference Column="Expr1049"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1052"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1033"></ColumnReference><ColumnReference Column="Expr1050"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1053"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1029"></ColumnReference><ColumnReference Column="Expr1046"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1054"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="Expr1030"></ColumnReference><ColumnReference Column="Expr1047"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1055"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="Expr1031"></ColumnReference><ColumnReference Column="Expr1048"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="16" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="92.0571" EstimateIO="0" EstimateCPU="9.20571e-07" AvgRowSize="91" EstimatedTotalSubtreeCost="292.501" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1015"></ColumnReference><ScalarOperator ScalarString="&apos;store channel&apos;"><Const ConstValue="&apos;store channel&apos;"></Const></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1016"></ColumnReference><ScalarOperator ScalarString="&apos;store&apos;+[DSB_SF100].[dbo].[store].[s_store_id]"><Arithmetic Operation="ADD"><ScalarOperator><Const ConstValue="&apos;store&apos;"></Const></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="17" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="92.0571" EstimateIO="0" EstimateCPU="0" AvgRowSize="78" EstimatedTotalSubtreeCost="292.501" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1012"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1162]=(0) THEN NULL ELSE [Expr1163] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1162"></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="Expr1163"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1013"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1164]=(0) THEN NULL ELSE [Expr1165] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1164"></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="Expr1165"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1014"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1166]=(0) THEN NULL ELSE [Expr1167] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1166"></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="Expr1167"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="18" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="92.0571" EstimateIO="0" EstimateCPU="0.00559101" AvgRowSize="78" EstimatedTotalSubtreeCost="292.501" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference><ColumnReference Column="Expr1162"></ColumnReference><ColumnReference Column="Expr1163"></ColumnReference><ColumnReference Column="Expr1164"></ColumnReference><ColumnReference Column="Expr1165"></ColumnReference><ColumnReference Column="Expr1166"></ColumnReference><ColumnReference Column="Expr1167"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1162"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([DSB_SF100].[dbo].[store_sales].[ss_ext_sales_price])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1163"></ColumnReference><ScalarOperator ScalarString="SUM([DSB_SF100].[dbo].[store_sales].[ss_ext_sales_price])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1164"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1065])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1065"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1165"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1065])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1065"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1166"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1116])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1116"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1167"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1116])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1116"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[store].[s_store_id] = [DSB_SF100].[dbo].[store].[s_store_id]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="19" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="5210.57" EstimateIO="0" EstimateCPU="5.21057e-05" AvgRowSize="42" EstimatedTotalSubtreeCost="292.496" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference><ColumnReference Column="Expr1065"></ColumnReference><ColumnReference Column="Expr1116"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1116"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[store_sales].[ss_net_profit]-[Expr1066]"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_net_profit"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1066"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="20" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="5210.57" EstimateIO="0" EstimateCPU="5.21057e-05" AvgRowSize="47" EstimatedTotalSubtreeCost="292.496" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_net_profit"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference><ColumnReference Column="Expr1065"></ColumnReference><ColumnReference Column="Expr1066"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1065"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [DSB_SF100].[dbo].[store_returns].[sr_return_amt] IS NOT NULL THEN [DSB_SF100].[dbo].[store_returns].[sr_return_amt] ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1066"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [DSB_SF100].[dbo].[store_returns].[sr_net_loss] IS NOT NULL THEN [DSB_SF100].[dbo].[store_returns].[sr_net_loss] ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_net_loss"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_net_loss"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="21" PhysicalOp="Hash Match" LogicalOp="Left Outer Join" EstimateRows="5210.57" EstimateIO="0" EstimateCPU="0.0201278" AvgRowSize="47" EstimatedTotalSubtreeCost="292.495" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_net_profit"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_net_loss"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1098"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ticket_number"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_ticket_number"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[store_sales].[ss_item_sk]=[DSB_SF100].[dbo].[store_returns].[sr_item_sk] AND [DSB_SF100].[dbo].[store_sales].[ss_ticket_number]=[DSB_SF100].[dbo].[store_returns].[sr_ticket_number]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_item_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ticket_number"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_ticket_number"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="22" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="4193.61" EstimateIO="0" EstimateCPU="0.00478464" AvgRowSize="45" EstimatedTotalSubtreeCost="251.847" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ticket_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_net_profit"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="23" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="402" EstimatedRowsRead="402" EstimateIO="0.003125" EstimateCPU="5.992e-05" AvgRowSize="31" EstimatedTotalSubtreeCost="0.00318492" TableCardinality="402" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_store_id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="24" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="4193.61" EstimateIO="0" EstimateCPU="0.00412258" AvgRowSize="29" EstimatedTotalSubtreeCost="251.839" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ticket_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_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_Bitmap1108"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="25" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="31.3758" EstimatedRowsRead="73064" EstimateIO="0.0208828" EstimateCPU="0.00805274" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0289356" TableCardinality="73064" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_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="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_date]&gt;=&apos;2000-06-06&apos; AND [DSB_SF100].[dbo].[date_dim].[d_date]&lt;=&apos;2000-07-06&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2000-06-06&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2000-07-06&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="26" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="279188" EstimateIO="0" EstimateCPU="0.00599228" AvgRowSize="33" EstimatedTotalSubtreeCost="251.756" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ticket_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_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_Bitmap1109"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_promo_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_promo_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="28" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="276.122" EstimatedRowsRead="1000" EstimateIO="0.003125" EstimateCPU="0.0001257" AvgRowSize="28" EstimatedTotalSubtreeCost="0.0032507" TableCardinality="1000" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_promo_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_email"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_tv"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_radio"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_press"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_event"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_promo_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_email"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_tv"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_radio"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_press"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_event"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[promotion].[p_channel_email]=&apos;Y&apos; AND [DSB_SF100].[dbo].[promotion].[p_channel_tv]=&apos;Y&apos; AND [DSB_SF100].[dbo].[promotion].[p_channel_radio]=&apos;Y&apos; AND [DSB_SF100].[dbo].[promotion].[p_channel_press]=&apos;N&apos; AND [DSB_SF100].[dbo].[promotion].[p_channel_event]=&apos;N&apos; AND [DSB_SF100].[dbo].[promotion].[p_channel_email]=&apos;Y&apos; AND [DSB_SF100].[dbo].[promotion].[p_channel_tv]=&apos;Y&apos; AND [DSB_SF100].[dbo].[promotion].[p_channel_radio]=&apos;Y&apos; AND [DSB_SF100].[dbo].[promotion].[p_channel_press]=&apos;N&apos; AND [DSB_SF100].[dbo].[promotion].[p_channel_event]=&apos;N&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_email"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Y&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_tv"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Y&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_radio"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Y&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_press"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;N&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_event"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;N&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_email"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Y&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_tv"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Y&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_radio"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Y&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_press"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;N&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_event"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;N&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="29" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.01111e+06" EstimateIO="0" EstimateCPU="0.0152168" AvgRowSize="37" EstimatedTotalSubtreeCost="251.742" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_promo_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ticket_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_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_Bitmap1103"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="31" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="6171.36" EstimatedRowsRead="203145" EstimateIO="0.0979024" EstimateCPU="0.0223617" AvgRowSize="26" EstimatedTotalSubtreeCost="0.120264" TableCardinality="203145" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="([DSB_SF100].[dbo].[item].[i_category]=&apos;Electronics&apos; OR [DSB_SF100].[dbo].[item].[i_category]=&apos;Home&apos;) AND [DSB_SF100].[dbo].[item].[i_current_price]&gt;(50.00)"><Logical Operation="AND"><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Electronics&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Home&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_current_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(50.00)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="32" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="3.0528e+07" EstimatedRowsRead="2.88583e+08" EstimateIO="219.195" EstimateCPU="31.7442" AvgRowSize="42" EstimatedTotalSubtreeCost="250.94" TableCardinality="2.88583e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_promo_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ticket_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_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="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_promo_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ticket_number"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_ext_sales_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_net_profit"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[store_sales].[ss_wholesale_cost]&gt;=(85.00) AND [DSB_SF100].[dbo].[store_sales].[ss_wholesale_cost]&lt;=(100.00) AND [DSB_SF100].[dbo].[store_sales].[ss_sold_date_sk] IS NOT NULL AND [DSB_SF100].[dbo].[store_sales].[ss_store_sk] IS NOT NULL AND [DSB_SF100].[dbo].[store_sales].[ss_promo_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_wholesale_cost"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(85.00)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_wholesale_cost"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(100.00)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_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="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_store_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_sales]" Column="ss_promo_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp><RelOp NodeId="33" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7.22732e+07" EstimatedRowsRead="7.22732e+07" EstimateIO="32.678" EstimateCPU="7.95007" AvgRowSize="25" EstimatedTotalSubtreeCost="40.628" TableCardinality="7.22732e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_ticket_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt"></ColumnReference><ColumnReference Database="[DSB_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="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_ticket_number"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_net_loss"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp><RelOp NodeId="34" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2162.3" EstimateIO="0" EstimateCPU="2.1623e-05" AvgRowSize="99" EstimatedTotalSubtreeCost="138.49" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1029"></ColumnReference><ColumnReference Column="Expr1030"></ColumnReference><ColumnReference Column="Expr1031"></ColumnReference><ColumnReference Column="Expr1032"></ColumnReference><ColumnReference Column="Expr1033"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1032"></ColumnReference><ScalarOperator ScalarString="&apos;catalog channel&apos;"><Const ConstValue="&apos;catalog channel&apos;"></Const></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1033"></ColumnReference><ScalarOperator ScalarString="&apos;catalog_page&apos;+[DSB_SF100].[dbo].[catalog_page].[cp_catalog_page_id]"><Arithmetic Operation="ADD"><ScalarOperator><Const ConstValue="&apos;catalog_page&apos;"></Const></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_page]" Column="cp_catalog_page_id"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="35" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2162.3" EstimateIO="0" EstimateCPU="0" AvgRowSize="78" EstimatedTotalSubtreeCost="138.49" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_page]" Column="cp_catalog_page_id"></ColumnReference><ColumnReference Column="Expr1029"></ColumnReference><ColumnReference Column="Expr1030"></ColumnReference><ColumnReference Column="Expr1031"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1029"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1168]=(0) THEN NULL ELSE [Expr1169] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1168"></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="Expr1169"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1030"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1170]=(0) THEN NULL ELSE [Expr1171] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1170"></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="Expr1171"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1031"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1172]=(0) THEN NULL ELSE [Expr1173] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1172"></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="Expr1173"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="36" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2162.3" EstimateIO="0" EstimateCPU="0.0118039" AvgRowSize="78" EstimatedTotalSubtreeCost="138.49" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_page]" Column="cp_catalog_page_id"></ColumnReference><ColumnReference Column="Expr1168"></ColumnReference><ColumnReference Column="Expr1169"></ColumnReference><ColumnReference Column="Expr1170"></ColumnReference><ColumnReference Column="Expr1171"></ColumnReference><ColumnReference Column="Expr1172"></ColumnReference><ColumnReference Column="Expr1173"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1168"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([DSB_SF100].[dbo].[catalog_sales].[cs_ext_sales_price])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1169"></ColumnReference><ScalarOperator ScalarString="SUM([DSB_SF100].[dbo].[catalog_sales].[cs_ext_sales_price])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1170"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1067])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1067"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1171"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1067])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1067"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1172"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1141])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1141"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1173"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1141])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1141"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_page]" Column="cp_catalog_page_id"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[catalog_page].[cp_catalog_page_id] = [DSB_SF100].[dbo].[catalog_page].[cp_catalog_page_id]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_page]" Column="cp_catalog_page_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_page]" Column="cp_catalog_page_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="37" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="3196.35" EstimateIO="0" EstimateCPU="3.19635e-05" AvgRowSize="42" EstimatedTotalSubtreeCost="138.478" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_page]" Column="cp_catalog_page_id"></ColumnReference><ColumnReference Column="Expr1067"></ColumnReference><ColumnReference Column="Expr1141"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1141"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[catalog_sales].[cs_net_profit]-[Expr1068]"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_profit"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1068"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="38" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="3196.35" EstimateIO="0" EstimateCPU="3.19635e-05" AvgRowSize="47" EstimatedTotalSubtreeCost="138.478" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_profit"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_page]" Column="cp_catalog_page_id"></ColumnReference><ColumnReference Column="Expr1067"></ColumnReference><ColumnReference Column="Expr1068"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1067"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [DSB_SF100].[dbo].[catalog_returns].[cr_return_amount] IS NOT NULL THEN [DSB_SF100].[dbo].[catalog_returns].[cr_return_amount] ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_amount"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_amount"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1068"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [DSB_SF100].[dbo].[catalog_returns].[cr_net_loss] IS NOT NULL THEN [DSB_SF100].[dbo].[catalog_returns].[cr_net_loss] ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_net_loss"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_net_loss"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="39" PhysicalOp="Hash Match" LogicalOp="Left Outer Join" EstimateRows="3196.35" EstimateIO="0" EstimateCPU="0.0138484" AvgRowSize="47" EstimatedTotalSubtreeCost="138.478" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_profit"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_amount"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_net_loss"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_page]" Column="cp_catalog_page_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1118"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_order_number"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_order_number"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[catalog_sales].[cs_item_sk]=[DSB_SF100].[dbo].[catalog_returns].[cr_item_sk] AND [DSB_SF100].[dbo].[catalog_sales].[cs_order_number]=[DSB_SF100].[dbo].[catalog_returns].[cr_order_number]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_item_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_order_number"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_order_number"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="40" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2776.53" EstimateIO="0" EstimateCPU="0.0083896" AvgRowSize="45" EstimatedTotalSubtreeCost="126.29" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_profit"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_page]" Column="cp_catalog_page_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1132"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_catalog_page_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_page]" Column="cp_catalog_page_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="41" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2730.41" EstimateIO="0" EstimateCPU="0.00335744" AvgRowSize="29" EstimatedTotalSubtreeCost="126.266" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_catalog_page_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_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_Bitmap1138"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="42" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="31.3758" EstimatedRowsRead="73064" EstimateIO="0.0208828" EstimateCPU="0.00805274" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0289356" TableCardinality="73064" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_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="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_date]&gt;=&apos;2000-06-06&apos; AND [DSB_SF100].[dbo].[date_dim].[d_date]&lt;=&apos;2000-07-06&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2000-06-06&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2000-07-06&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="43" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="187832" EstimateIO="0" EstimateCPU="0.00470039" AvgRowSize="33" EstimatedTotalSubtreeCost="126.183" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_catalog_page_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_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_Bitmap1139"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_promo_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_promo_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="45" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="276.122" EstimatedRowsRead="1000" EstimateIO="0.003125" EstimateCPU="0.0001257" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0032507" TableCardinality="1000" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_promo_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_email"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_tv"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_radio"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_press"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_event"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_promo_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_email"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_tv"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_radio"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_press"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_event"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[promotion].[p_channel_email]=&apos;Y&apos; AND [DSB_SF100].[dbo].[promotion].[p_channel_tv]=&apos;Y&apos; AND [DSB_SF100].[dbo].[promotion].[p_channel_radio]=&apos;Y&apos; AND [DSB_SF100].[dbo].[promotion].[p_channel_press]=&apos;N&apos; AND [DSB_SF100].[dbo].[promotion].[p_channel_event]=&apos;N&apos; AND [DSB_SF100].[dbo].[promotion].[p_channel_email]=&apos;Y&apos; AND [DSB_SF100].[dbo].[promotion].[p_channel_tv]=&apos;Y&apos; AND [DSB_SF100].[dbo].[promotion].[p_channel_radio]=&apos;Y&apos; AND [DSB_SF100].[dbo].[promotion].[p_channel_press]=&apos;N&apos; AND [DSB_SF100].[dbo].[promotion].[p_channel_event]=&apos;N&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_email"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Y&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_tv"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Y&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_radio"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Y&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_press"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;N&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_event"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;N&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_email"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Y&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_tv"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Y&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_radio"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Y&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_press"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;N&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_event"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;N&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="46" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="680249" EstimateIO="0" EstimateCPU="0.0128173" AvgRowSize="37" EstimatedTotalSubtreeCost="126.171" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_catalog_page_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_promo_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_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_Bitmap1124"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="48" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="6171.36" EstimatedRowsRead="203145" EstimateIO="0.167704" EstimateCPU="0.0223617" AvgRowSize="45" EstimatedTotalSubtreeCost="0.190066" TableCardinality="203145" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="([DSB_SF100].[dbo].[item].[i_category]=&apos;Electronics&apos; OR [DSB_SF100].[dbo].[item].[i_category]=&apos;Home&apos;) AND [DSB_SF100].[dbo].[item].[i_current_price]&gt;(50.00)"><Logical Operation="AND"><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Electronics&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Home&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_current_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(50.00)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="49" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.0673e+07" EstimatedRowsRead="1.44208e+08" EstimateIO="109.535" EstimateCPU="15.8629" AvgRowSize="42" EstimatedTotalSubtreeCost="125.398" TableCardinality="1.44208e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_catalog_page_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_promo_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_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="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_catalog_page_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_promo_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_order_number"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_profit"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[catalog_sales].[cs_wholesale_cost]&gt;=(85.00) AND [DSB_SF100].[dbo].[catalog_sales].[cs_wholesale_cost]&lt;=(100.00) AND [DSB_SF100].[dbo].[catalog_sales].[cs_sold_date_sk] IS NOT NULL AND [DSB_SF100].[dbo].[catalog_sales].[cs_catalog_page_sk] IS NOT NULL AND [DSB_SF100].[dbo].[catalog_sales].[cs_promo_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_wholesale_cost"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(85.00)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_wholesale_cost"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(100.00)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_catalog_page_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_promo_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp><RelOp NodeId="50" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="20447" EstimatedRowsRead="20447" EstimateIO="0.0138472" EstimateCPU="0.00226487" AvgRowSize="31" EstimatedTotalSubtreeCost="0.0161121" TableCardinality="20447" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_page]" Column="cp_catalog_page_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_page]" Column="cp_catalog_page_id"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_page]" Column="cp_catalog_page_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_page]" Column="cp_catalog_page_id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_page]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp></Hash></RelOp><RelOp NodeId="51" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.1652e+07" EstimatedRowsRead="2.1652e+07" EstimateIO="9.79154" EstimateCPU="2.38174" AvgRowSize="25" EstimatedTotalSubtreeCost="12.1733" TableCardinality="2.1652e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_amount"></ColumnReference><ColumnReference Database="[DSB_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="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_order_number"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_return_amount"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Column="cr_net_loss"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[catalog_returns]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp><RelOp NodeId="52" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="9.04153" EstimateIO="0" EstimateCPU="9.04153e-08" AvgRowSize="93" EstimatedTotalSubtreeCost="71.4064" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1046"></ColumnReference><ColumnReference Column="Expr1047"></ColumnReference><ColumnReference Column="Expr1048"></ColumnReference><ColumnReference Column="Expr1049"></ColumnReference><ColumnReference Column="Expr1050"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1049"></ColumnReference><ScalarOperator ScalarString="&apos;web channel&apos;"><Const ConstValue="&apos;web channel&apos;"></Const></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1050"></ColumnReference><ScalarOperator ScalarString="&apos;web_site&apos;+[DSB_SF100].[dbo].[web_site].[web_site_id]"><Arithmetic Operation="ADD"><ScalarOperator><Const ConstValue="&apos;web_site&apos;"></Const></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_id"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="53" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="9.04153" EstimateIO="0" EstimateCPU="0" AvgRowSize="78" EstimatedTotalSubtreeCost="71.4064" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_id"></ColumnReference><ColumnReference Column="Expr1046"></ColumnReference><ColumnReference Column="Expr1047"></ColumnReference><ColumnReference Column="Expr1048"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1046"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1174]=(0) THEN NULL ELSE [Expr1175] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1174"></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="Expr1175"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1047"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1176]=(0) THEN NULL ELSE [Expr1177] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1176"></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="Expr1177"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1048"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1178]=(0) THEN NULL ELSE [Expr1179] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1178"></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="Expr1179"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="54" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="9.04153" EstimateIO="0" EstimateCPU="0.00310316" AvgRowSize="78" EstimatedTotalSubtreeCost="71.4064" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_id"></ColumnReference><ColumnReference Column="Expr1174"></ColumnReference><ColumnReference Column="Expr1175"></ColumnReference><ColumnReference Column="Expr1176"></ColumnReference><ColumnReference Column="Expr1177"></ColumnReference><ColumnReference Column="Expr1178"></ColumnReference><ColumnReference Column="Expr1179"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1174"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([DSB_SF100].[dbo].[web_sales].[ws_ext_sales_price])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1175"></ColumnReference><ScalarOperator ScalarString="SUM([DSB_SF100].[dbo].[web_sales].[ws_ext_sales_price])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1176"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1069])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1069"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1177"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1069])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1069"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1178"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1161])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1161"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1179"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1161])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1161"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_id"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[web_site].[web_site_id] = [DSB_SF100].[dbo].[web_site].[web_site_id]"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></BuildResidual><RelOp NodeId="55" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1939.26" EstimateIO="0" EstimateCPU="1.93926e-05" AvgRowSize="42" EstimatedTotalSubtreeCost="71.4033" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_id"></ColumnReference><ColumnReference Column="Expr1069"></ColumnReference><ColumnReference Column="Expr1161"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1161"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[web_sales].[ws_net_profit]-[Expr1070]"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_profit"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1070"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="56" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1939.26" EstimateIO="0" EstimateCPU="1.93926e-05" AvgRowSize="47" EstimatedTotalSubtreeCost="71.4033" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_profit"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_id"></ColumnReference><ColumnReference Column="Expr1069"></ColumnReference><ColumnReference Column="Expr1070"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1069"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [DSB_SF100].[dbo].[web_returns].[wr_return_amt] IS NOT NULL THEN [DSB_SF100].[dbo].[web_returns].[wr_return_amt] ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1070"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [DSB_SF100].[dbo].[web_returns].[wr_net_loss] IS NOT NULL THEN [DSB_SF100].[dbo].[web_returns].[wr_net_loss] ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_net_loss"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_net_loss"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="57" PhysicalOp="Hash Match" LogicalOp="Left Outer Join" EstimateRows="1939.26" EstimateIO="0" EstimateCPU="0.00885604" AvgRowSize="47" EstimatedTotalSubtreeCost="71.4032" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_profit"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_net_loss"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1143"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_order_number"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_order_number"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[web_sales].[ws_item_sk]=[DSB_SF100].[dbo].[web_returns].[wr_item_sk] AND [DSB_SF100].[dbo].[web_sales].[ws_order_number]=[DSB_SF100].[dbo].[web_returns].[wr_order_number]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_item_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_order_number"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_order_number"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="58" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1618.2" EstimateIO="0" EstimateCPU="0.00268524" AvgRowSize="45" EstimatedTotalSubtreeCost="63.2963" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_profit"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_web_site_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="59" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="24" EstimatedRowsRead="24" EstimateIO="0.003125" EstimateCPU="1.834e-05" AvgRowSize="31" EstimatedTotalSubtreeCost="0.00314334" TableCardinality="24" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_id"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_site]" Column="web_site_id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[web_site]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="60" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1618.2" EstimateIO="0" EstimateCPU="0.00272052" AvgRowSize="29" EstimatedTotalSubtreeCost="63.2905" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_web_site_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_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_Bitmap1153"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="61" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="31.3758" EstimatedRowsRead="73064" EstimateIO="0.0208828" EstimateCPU="0.00805274" AvgRowSize="14" EstimatedTotalSubtreeCost="0.0289356" TableCardinality="73064" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_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="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="3" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[date_dim].[d_date]&gt;=&apos;2000-06-06&apos; AND [DSB_SF100].[dbo].[date_dim].[d_date]&lt;=&apos;2000-07-06&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2000-06-06&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2000-07-06&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="62" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="110650" EstimateIO="0" EstimateCPU="0.00360895" AvgRowSize="33" EstimatedTotalSubtreeCost="63.2085" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_web_site_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_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_Bitmap1154"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_promo_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_promo_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="64" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="276.122" EstimatedRowsRead="1000" EstimateIO="0.003125" EstimateCPU="0.0001257" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0032507" TableCardinality="1000" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_promo_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_email"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_tv"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_radio"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_press"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_event"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_promo_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_email"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_tv"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_radio"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_press"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_event"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Index="[ClusteredIndex]" TableReferenceId="3" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[promotion].[p_channel_email]=&apos;Y&apos; AND [DSB_SF100].[dbo].[promotion].[p_channel_tv]=&apos;Y&apos; AND [DSB_SF100].[dbo].[promotion].[p_channel_radio]=&apos;Y&apos; AND [DSB_SF100].[dbo].[promotion].[p_channel_press]=&apos;N&apos; AND [DSB_SF100].[dbo].[promotion].[p_channel_event]=&apos;N&apos; AND [DSB_SF100].[dbo].[promotion].[p_channel_email]=&apos;Y&apos; AND [DSB_SF100].[dbo].[promotion].[p_channel_tv]=&apos;Y&apos; AND [DSB_SF100].[dbo].[promotion].[p_channel_radio]=&apos;Y&apos; AND [DSB_SF100].[dbo].[promotion].[p_channel_press]=&apos;N&apos; AND [DSB_SF100].[dbo].[promotion].[p_channel_event]=&apos;N&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_email"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Y&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_tv"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Y&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_radio"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Y&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_press"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;N&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_event"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;N&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_email"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Y&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_tv"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Y&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_radio"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Y&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_press"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;N&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[promotion]" Column="p_channel_event"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;N&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="65" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="400729" EstimateIO="0" EstimateCPU="0.0107985" AvgRowSize="37" EstimatedTotalSubtreeCost="63.1973" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_web_site_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_promo_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_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_Bitmap1148"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="67" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="6171.36" EstimatedRowsRead="203145" EstimateIO="0.167704" EstimateCPU="0.0223617" AvgRowSize="45" EstimatedTotalSubtreeCost="0.190066" TableCardinality="203145" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Index="[ClusteredIndex]" TableReferenceId="3" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="([DSB_SF100].[dbo].[item].[i_category]=&apos;Electronics&apos; OR [DSB_SF100].[dbo].[item].[i_category]=&apos;Home&apos;) AND [DSB_SF100].[dbo].[item].[i_current_price]&gt;(50.00)"><Logical Operation="AND"><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Electronics&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_category"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Home&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[item]" Column="i_current_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(50.00)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="68" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.23847e+07" EstimatedRowsRead="7.1845e+07" EstimateIO="54.5721" EstimateCPU="7.90296" AvgRowSize="42" EstimatedTotalSubtreeCost="62.4751" TableCardinality="7.1845e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_web_site_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_promo_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference><ColumnReference Database="[DSB_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="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_web_site_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_promo_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_order_number"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_profit"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[web_sales].[ws_wholesale_cost]&gt;=(85.00) AND [DSB_SF100].[dbo].[web_sales].[ws_wholesale_cost]&lt;=(100.00) AND [DSB_SF100].[dbo].[web_sales].[ws_sold_date_sk] IS NOT NULL AND [DSB_SF100].[dbo].[web_sales].[ws_web_site_sk] IS NOT NULL AND [DSB_SF100].[dbo].[web_sales].[ws_promo_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_wholesale_cost"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(85.00)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_wholesale_cost"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(100.00)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_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="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_web_site_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_promo_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp></Hash></RelOp><RelOp NodeId="69" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.44021e+07" EstimatedRowsRead="1.44021e+07" EstimateIO="6.51375" EstimateCPU="1.58425" AvgRowSize="25" EstimatedTotalSubtreeCost="8.09799" TableCardinality="1.44021e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_item_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_order_number"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference><ColumnReference Database="[DSB_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="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_item_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_order_number"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_return_amt"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Column="wr_net_loss"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[web_returns]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></Concat></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></TopSort></RelOp></Move></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
