<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.612" Build="18.0.277.116"><BatchSequence><Batch><Statements><StmtSimple StatementText="WITH customer_total_return AS (&#xa;  SELECT&#xa;    sr_customer_sk AS ctr_customer_sk,&#xa;    sr_store_sk AS ctr_store_sk,&#xa;    sr_reason_sk AS ctr_reason_sk,&#xa;    SUM(sr_return_amt_inc_tax) AS ctr_total_return&#xa;  FROM store_returns, date_dim&#xa;  WHERE&#xa;    sr_returned_date_sk = d_date_sk&#xa;    AND d_year = 1999&#xa;    AND sr_return_amt / sr_return_quantity BETWEEN 80 AND 139&#xa;  GROUP BY&#xa;    sr_customer_sk,&#xa;    sr_store_sk,&#xa;    sr_reason_sk&#xa;)&#xa;SELECT&#xa;TOP 100&#xa;  c_customer_id&#xa;FROM customer_total_return AS ctr1, store, customer, customer_demographics&#xa;WHERE&#xa;  ctr1.ctr_total_return &gt; (&#xa;    SELECT&#xa;      AVG(ctr_total_return) * 1.2&#xa;    FROM customer_total_return AS ctr2&#xa;    WHERE&#xa;      ctr1.ctr_store_sk = ctr2.ctr_store_sk&#xa;  )&#xa;  AND ctr1.ctr_reason_sk BETWEEN 72 AND 75&#xa;  AND s_store_sk = ctr1.ctr_store_sk&#xa;  AND s_state IN (&apos;IA&apos;, &apos;KS&apos;, &apos;NC&apos;)&#xa;  AND ctr1.ctr_customer_sk = c_customer_sk&#xa;  AND c_current_cdemo_sk = cd_demo_sk&#xa;  AND cd_marital_status IN (&apos;U&apos;, &apos;D&apos;)&#xa;  AND cd_education_status IN (&apos;2 yr Degree&apos;, &apos;College&apos;)&#xa;  AND cd_gender = &apos;F&apos;&#xa;  AND c_birth_month = 8&#xa;  AND c_birth_year BETWEEN 1987 AND 1993&#xa;ORDER BY&#xa;  c_customer_id" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="166.845" StatementEstRows="1.75871" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x1A533BCB5300639E" QueryPlanHash="0x9C45ED7859576BD2" 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="360" CompileTime="58" CompileCPU="58" CompileMemory="7304"><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: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:31:51.36" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_7B5B524B]" Table="[store_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:57:49.57" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000D_797309D9]" Table="[customer]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:31:54.43" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000C_7B5B524B]" Table="[store_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:31:52.00" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000009_7B5B524B]" Table="[store_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:57:54.05" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_6FE99F9F]" Table="[customer_demographics]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:31:53.63" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000B_7B5B524B]" Table="[store_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:57:50.83" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_797309D9]" Table="[customer]" 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:31:49.81" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000008_7B5B524B]" Table="[store_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:31:52.27" ModificationCount="0" SamplingPercent="73.9589" Statistics="[_WA_Sys_00000007_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:31:50.65" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000004_7B5B524B]" Table="[store_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:57:49.97" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000003_797309D9]" Table="[customer]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:57:53.24" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000004_6FE99F9F]" Table="[customer_demographics]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:31:49.09" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000E_7B5B524B]" Table="[store_returns]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:58:06.18" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000E_797309D9]" Table="[customer]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:57:53.70" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000002_6FE99F9F]" Table="[customer_demographics]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T18:31:52.72" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000019_778AC167]" Table="[store]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:57:53.47" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000003_6FE99F9F]" Table="[customer_demographics]" Schema="[dbo]" Database="[DSB_SF100]"></StatisticsInfo></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.75871" EstimateIO="0" EstimateCPU="1.75871e-07" AvgRowSize="19" EstimatedTotalSubtreeCost="166.845" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ScalarOperator ScalarString="[DSB_SF100].[dbo].[customer].[c_customer_id]"><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="1.75871" EstimateIO="0" EstimateCPU="1.75871e-07" AvgRowSize="19" EstimatedTotalSubtreeCost="166.845" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></OutputList><Move DistributionType="Return" MoveTopology="OneToOne"><RelOp NodeId="3" PhysicalOp="Sort" LogicalOp="TopN Sort" EstimateRows="1.75871" EstimateIO="0.00563063" EstimateCPU="0.000150364" AvgRowSize="19" EstimatedTotalSubtreeCost="166.845" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><TopSort Distinct="0" Rows="100"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="4" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.75871" EstimateIO="0" EstimateCPU="0.00178475" AvgRowSize="19" EstimatedTotalSubtreeCost="166.839" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1034"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_current_cdemo_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Column="cd_demo_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="5" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="4.92134" EstimateIO="0" EstimateCPU="0.00193371" AvgRowSize="23" EstimatedTotalSubtreeCost="165.583" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_current_cdemo_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1035"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_customer_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="6" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="159.328" EstimateIO="0" EstimateCPU="0.00202329" AvgRowSize="11" EstimatedTotalSubtreeCost="164.093" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_customer_sk"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1036"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[store_returns].[sr_store_sk]=[DSB_SF100].[dbo].[store_returns].[sr_store_sk] AND [Expr1004]&gt;[Expr1016]*(1.2)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Column="Expr1004"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Column="Expr1016"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1.2)"></Const></ScalarOperator></Arithmetic></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="7" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="52" EstimateIO="0" EstimateCPU="0.00187566" AvgRowSize="28" EstimatedTotalSubtreeCost="81.2731" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1037"></ColumnReference></DefinedValue></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_returns]" Column="sr_store_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="9" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="52" EstimatedRowsRead="402" EstimateIO="0.003125" EstimateCPU="5.992e-05" AvgRowSize="17" 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_state"></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_state"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[store].[s_state]=&apos;IA&apos; OR [DSB_SF100].[dbo].[store].[s_state]=&apos;KS&apos; OR [DSB_SF100].[dbo].[store].[s_state]=&apos;NC&apos;"><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;IA&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;KS&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store]" Column="s_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;NC&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="10" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="201" EstimateIO="0" EstimateCPU="0" AvgRowSize="28" EstimatedTotalSubtreeCost="81.2669" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1016"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1042]=(0) THEN NULL ELSE [Expr1043]/CONVERT_IMPLICIT(decimal(19,0),[Expr1042],0) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1042"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Expr1043"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="19" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1042"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="11" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="201" EstimateIO="0" EstimateCPU="0.443421" AvgRowSize="28" EstimatedTotalSubtreeCost="81.2669" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference><ColumnReference Column="Expr1042"></ColumnReference><ColumnReference Column="Expr1043"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1042"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1015])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1015"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1043"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1015])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1015"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference></HashKeysBuild><RelOp NodeId="12" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.88854e+06" EstimateIO="0" EstimateCPU="0" AvgRowSize="28" EstimatedTotalSubtreeCost="80.8235" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1015"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1040]=(0) THEN NULL ELSE [Expr1041] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1040"></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="Expr1041"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="13" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1.88854e+06" EstimateIO="0" EstimateCPU="3.49976" AvgRowSize="28" EstimatedTotalSubtreeCost="80.8235" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference><ColumnReference Column="Expr1040"></ColumnReference><ColumnReference Column="Expr1041"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1040"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1041"></ColumnReference><ScalarOperator ScalarString="SUM([DSB_SF100].[dbo].[store_returns].[sr_return_amt_inc_tax])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt_inc_tax"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_reason_sk"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[store_returns].[sr_customer_sk] = [DSB_SF100].[dbo].[store_returns].[sr_customer_sk] AND [DSB_SF100].[dbo].[store_returns].[sr_store_sk] = [DSB_SF100].[dbo].[store_returns].[sr_store_sk] AND [DSB_SF100].[dbo].[store_returns].[sr_reason_sk] = [DSB_SF100].[dbo].[store_returns].[sr_reason_sk]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_customer_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_customer_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_reason_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="14" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.88854e+06" EstimateIO="0" EstimateCPU="0.744594" AvgRowSize="24" EstimatedTotalSubtreeCost="77.3238" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_reason_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt_inc_tax"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1038"></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_returns]" Column="sr_returned_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="15" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="364.367" EstimatedRowsRead="73064" EstimateIO="0.0222041" EstimateCPU="0.00805274" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0302569" 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_year]=(1999)"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1999)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="16" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1.17182e+07" EstimateIO="0" EstimateCPU="20.2184" AvgRowSize="28" EstimatedTotalSubtreeCost="76.5308" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_returned_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_reason_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt_inc_tax"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="17" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.17182e+07" EstimatedRowsRead="7.22732e+07" EstimateIO="48.3623" EstimateCPU="7.95007" AvgRowSize="37" EstimatedTotalSubtreeCost="56.3123" TableCardinality="7.22732e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_returned_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_reason_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_quantity"></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_return_amt_inc_tax"></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_returned_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_customer_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_reason_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_quantity"></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_return_amt_inc_tax"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[store_returns].[sr_returned_date_sk] IS NOT NULL AND [DSB_SF100].[dbo].[store_returns].[sr_store_sk] IS NOT NULL AND [DSB_SF100].[dbo].[store_returns].[sr_return_amt_inc_tax] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_returned_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_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_returns]" Column="sr_return_amt_inc_tax"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[store_returns].[sr_return_amt]/CONVERT_IMPLICIT(decimal(10,0),[DSB_SF100].[dbo].[store_returns].[sr_return_quantity],0)&gt;=(80.0000000000000) AND [DSB_SF100].[dbo].[store_returns].[sr_return_amt]/CONVERT_IMPLICIT(decimal(10,0),[DSB_SF100].[dbo].[store_returns].[sr_return_quantity],0)&lt;=(139.0000000000000)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(80.0000000000000)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(139.0000000000000)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp><RelOp NodeId="18" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="553.476" EstimateIO="0" EstimateCPU="0" AvgRowSize="32" EstimatedTotalSubtreeCost="82.8179" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1004"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1044]=(0) THEN NULL ELSE [Expr1045] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1044"></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="Expr1045"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="19" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="553.476" EstimateIO="0" EstimateCPU="0.00280016" AvgRowSize="32" EstimatedTotalSubtreeCost="82.8179" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference><ColumnReference Column="Expr1044"></ColumnReference><ColumnReference Column="Expr1045"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1044"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1045"></ColumnReference><ScalarOperator ScalarString="SUM([DSB_SF100].[dbo].[store_returns].[sr_return_amt_inc_tax])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt_inc_tax"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_reason_sk"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[DSB_SF100].[dbo].[store_returns].[sr_customer_sk] = [DSB_SF100].[dbo].[store_returns].[sr_customer_sk] AND [DSB_SF100].[dbo].[store_returns].[sr_store_sk] = [DSB_SF100].[dbo].[store_returns].[sr_store_sk] AND [DSB_SF100].[dbo].[store_returns].[sr_reason_sk] = [DSB_SF100].[dbo].[store_returns].[sr_reason_sk]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_customer_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_customer_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_reason_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="20" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="553.476" EstimateIO="0" EstimateCPU="0.00234785" AvgRowSize="24" EstimatedTotalSubtreeCost="82.8151" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_reason_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt_inc_tax"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1039"></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_returns]" Column="sr_returned_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="21" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="364.367" EstimatedRowsRead="73064" EstimateIO="0.0222041" EstimateCPU="0.00805274" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0302569" 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_year]=(1999)"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1999)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="22" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="3434.25" EstimateIO="0" EstimateCPU="26.452" AvgRowSize="28" EstimatedTotalSubtreeCost="82.7643" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_returned_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_reason_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt_inc_tax"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="23" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="3434.25" EstimatedRowsRead="7.22732e+07" EstimateIO="48.3623" EstimateCPU="7.95007" AvgRowSize="37" EstimatedTotalSubtreeCost="56.3123" TableCardinality="7.22732e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_returned_date_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_reason_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_quantity"></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_return_amt_inc_tax"></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_returned_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_customer_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_store_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_reason_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_quantity"></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_return_amt_inc_tax"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[store_returns].[sr_reason_sk]&gt;=(72) AND [DSB_SF100].[dbo].[store_returns].[sr_reason_sk]&lt;=(75) AND [DSB_SF100].[dbo].[store_returns].[sr_returned_date_sk] IS NOT NULL AND [DSB_SF100].[dbo].[store_returns].[sr_customer_sk] IS NOT NULL AND [DSB_SF100].[dbo].[store_returns].[sr_store_sk] IS NOT NULL AND [DSB_SF100].[dbo].[store_returns].[sr_return_amt_inc_tax] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(72)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_reason_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(75)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_returned_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_customer_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_returns]" Column="sr_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_returns]" Column="sr_return_amt_inc_tax"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[store_returns].[sr_return_amt]/CONVERT_IMPLICIT(decimal(10,0),[DSB_SF100].[dbo].[store_returns].[sr_return_quantity],0)&gt;=(80.0000000000000) AND [DSB_SF100].[dbo].[store_returns].[sr_return_amt]/CONVERT_IMPLICIT(decimal(10,0),[DSB_SF100].[dbo].[store_returns].[sr_return_quantity],0)&lt;=(139.0000000000000)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(80.0000000000000)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_amt"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[store_returns]" Column="sr_return_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(139.0000000000000)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp></Hash></RelOp></Hash></RelOp></ComputeScalar></RelOp></Hash></RelOp><RelOp NodeId="24" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="53421.1" EstimatedRowsRead="1.99897e+06" EstimateIO="1.26765" EstimateCPU="0.219902" AvgRowSize="35" EstimatedTotalSubtreeCost="1.48755" TableCardinality="1.99897e+06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_current_cdemo_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="[customer]" Column="c_customer_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_customer_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_current_cdemo_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[customer].[c_birth_month]=(8) AND [DSB_SF100].[dbo].[customer].[c_birth_year]&gt;=(1987) AND [DSB_SF100].[dbo].[customer].[c_birth_year]&lt;=(1993) AND [DSB_SF100].[dbo].[customer].[c_current_cdemo_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_month"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(8)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1987)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_birth_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1993)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer]" Column="c_current_cdemo_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp><RelOp NodeId="26" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="292404" EstimatedRowsRead="1.91872e+06" EstimateIO="1.04336" EstimateCPU="0.211075" AvgRowSize="30" EstimatedTotalSubtreeCost="1.25443" TableCardinality="1.91872e+06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Column="cd_demo_sk"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Column="cd_gender"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Column="cd_marital_status"></ColumnReference><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Column="cd_education_status"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Column="cd_demo_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Column="cd_gender"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Column="cd_marital_status"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Column="cd_education_status"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[DSB_SF100].[dbo].[customer_demographics].[cd_gender]=&apos;F&apos; AND ([DSB_SF100].[dbo].[customer_demographics].[cd_marital_status]=&apos;D&apos; OR [DSB_SF100].[dbo].[customer_demographics].[cd_marital_status]=&apos;U&apos;) AND ([DSB_SF100].[dbo].[customer_demographics].[cd_education_status]=&apos;2 yr Degree&apos; OR [DSB_SF100].[dbo].[customer_demographics].[cd_education_status]=&apos;College&apos;) AND [DSB_SF100].[dbo].[customer_demographics].[cd_gender]=&apos;F&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Column="cd_gender"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;F&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Column="cd_marital_status"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;D&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Column="cd_marital_status"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;U&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Column="cd_education_status"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2 yr Degree&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Column="cd_education_status"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;College&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DSB_SF100]" Schema="[dbo]" Table="[customer_demographics]" Column="cd_gender"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;F&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></TopSort></RelOp></Move></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
