<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.612" Build="18.0.277.116"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT&#xa;TOP 100&#xa;  w_warehouse_name,&#xa;  w_warehouse_sq_ft,&#xa;  w_city,&#xa;  w_county,&#xa;  w_state,&#xa;  w_country,&#xa;  ship_carriers,&#xa;  year,&#xa;  SUM(jan_sales) AS jan_sales,&#xa;  SUM(feb_sales) AS feb_sales,&#xa;  SUM(mar_sales) AS mar_sales,&#xa;  SUM(apr_sales) AS apr_sales,&#xa;  SUM(may_sales) AS may_sales,&#xa;  SUM(jun_sales) AS jun_sales,&#xa;  SUM(jul_sales) AS jul_sales,&#xa;  SUM(aug_sales) AS aug_sales,&#xa;  SUM(sep_sales) AS sep_sales,&#xa;  SUM(oct_sales) AS oct_sales,&#xa;  SUM(nov_sales) AS nov_sales,&#xa;  SUM(dec_sales) AS dec_sales,&#xa;  SUM(jan_sales / w_warehouse_sq_ft) AS jan_sales_per_sq_foot,&#xa;  SUM(feb_sales / w_warehouse_sq_ft) AS feb_sales_per_sq_foot,&#xa;  SUM(mar_sales / w_warehouse_sq_ft) AS mar_sales_per_sq_foot,&#xa;  SUM(apr_sales / w_warehouse_sq_ft) AS apr_sales_per_sq_foot,&#xa;  SUM(may_sales / w_warehouse_sq_ft) AS may_sales_per_sq_foot,&#xa;  SUM(jun_sales / w_warehouse_sq_ft) AS jun_sales_per_sq_foot,&#xa;  SUM(jul_sales / w_warehouse_sq_ft) AS jul_sales_per_sq_foot,&#xa;  SUM(aug_sales / w_warehouse_sq_ft) AS aug_sales_per_sq_foot,&#xa;  SUM(sep_sales / w_warehouse_sq_ft) AS sep_sales_per_sq_foot,&#xa;  SUM(oct_sales / w_warehouse_sq_ft) AS oct_sales_per_sq_foot,&#xa;  SUM(nov_sales / w_warehouse_sq_ft) AS nov_sales_per_sq_foot,&#xa;  SUM(dec_sales / w_warehouse_sq_ft) AS dec_sales_per_sq_foot,&#xa;  SUM(jan_net) AS jan_net,&#xa;  SUM(feb_net) AS feb_net,&#xa;  SUM(mar_net) AS mar_net,&#xa;  SUM(apr_net) AS apr_net,&#xa;  SUM(may_net) AS may_net,&#xa;  SUM(jun_net) AS jun_net,&#xa;  SUM(jul_net) AS jul_net,&#xa;  SUM(aug_net) AS aug_net,&#xa;  SUM(sep_net) AS sep_net,&#xa;  SUM(oct_net) AS oct_net,&#xa;  SUM(nov_net) AS nov_net,&#xa;  SUM(dec_net) AS dec_net&#xa;FROM (&#xa;  SELECT&#xa;    w_warehouse_name,&#xa;    w_warehouse_sq_ft,&#xa;    w_city,&#xa;    w_county,&#xa;    w_state,&#xa;    w_country,&#xa;    &apos;BARIAN&apos; + &apos;,&apos; + &apos;ORIENTAL&apos; AS ship_carriers,&#xa;    d_year AS year,&#xa;    SUM(CASE WHEN d_moy = 1 THEN ws_ext_sales_price * ws_quantity ELSE 0 END) AS jan_sales,&#xa;    SUM(CASE WHEN d_moy = 2 THEN ws_ext_sales_price * ws_quantity ELSE 0 END) AS feb_sales,&#xa;    SUM(CASE WHEN d_moy = 3 THEN ws_ext_sales_price * ws_quantity ELSE 0 END) AS mar_sales,&#xa;    SUM(CASE WHEN d_moy = 4 THEN ws_ext_sales_price * ws_quantity ELSE 0 END) AS apr_sales,&#xa;    SUM(CASE WHEN d_moy = 5 THEN ws_ext_sales_price * ws_quantity ELSE 0 END) AS may_sales,&#xa;    SUM(CASE WHEN d_moy = 6 THEN ws_ext_sales_price * ws_quantity ELSE 0 END) AS jun_sales,&#xa;    SUM(CASE WHEN d_moy = 7 THEN ws_ext_sales_price * ws_quantity ELSE 0 END) AS jul_sales,&#xa;    SUM(CASE WHEN d_moy = 8 THEN ws_ext_sales_price * ws_quantity ELSE 0 END) AS aug_sales,&#xa;    SUM(CASE WHEN d_moy = 9 THEN ws_ext_sales_price * ws_quantity ELSE 0 END) AS sep_sales,&#xa;    SUM(CASE WHEN d_moy = 10 THEN ws_ext_sales_price * ws_quantity ELSE 0 END) AS oct_sales,&#xa;    SUM(CASE WHEN d_moy = 11 THEN ws_ext_sales_price * ws_quantity ELSE 0 END) AS nov_sales,&#xa;    SUM(CASE WHEN d_moy = 12 THEN ws_ext_sales_price * ws_quantity ELSE 0 END) AS dec_sales,&#xa;    SUM(CASE WHEN d_moy = 1 THEN ws_net_paid * ws_quantity ELSE 0 END) AS jan_net,&#xa;    SUM(CASE WHEN d_moy = 2 THEN ws_net_paid * ws_quantity ELSE 0 END) AS feb_net,&#xa;    SUM(CASE WHEN d_moy = 3 THEN ws_net_paid * ws_quantity ELSE 0 END) AS mar_net,&#xa;    SUM(CASE WHEN d_moy = 4 THEN ws_net_paid * ws_quantity ELSE 0 END) AS apr_net,&#xa;    SUM(CASE WHEN d_moy = 5 THEN ws_net_paid * ws_quantity ELSE 0 END) AS may_net,&#xa;    SUM(CASE WHEN d_moy = 6 THEN ws_net_paid * ws_quantity ELSE 0 END) AS jun_net,&#xa;    SUM(CASE WHEN d_moy = 7 THEN ws_net_paid * ws_quantity ELSE 0 END) AS jul_net,&#xa;    SUM(CASE WHEN d_moy = 8 THEN ws_net_paid * ws_quantity ELSE 0 END) AS aug_net,&#xa;    SUM(CASE WHEN d_moy = 9 THEN ws_net_paid * ws_quantity ELSE 0 END) AS sep_net,&#xa;    SUM(CASE WHEN d_moy = 10 THEN ws_net_paid * ws_quantity ELSE 0 END) AS oct_net,&#xa;    SUM(CASE WHEN d_moy = 11 THEN ws_net_paid * ws_quantity ELSE 0 END) AS nov_net,&#xa;    SUM(CASE WHEN d_moy = 12 THEN ws_net_paid * ws_quantity ELSE 0 END) AS dec_net&#xa;  FROM web_sales, warehouse, date_dim, time_dim, ship_mode&#xa;  WHERE&#xa;    ws_warehouse_sk = w_warehouse_sk&#xa;    AND ws_sold_date_sk = d" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="178.742" StatementEstRows="22.5" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x4D58F3AE4442DAB3" QueryPlanHash="0xEE8AB9D42EDEA03F" 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="1728" CompileTime="85" CompileCPU="85" CompileMemory="8816"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="524288" EstimatedPagesCached="488960" EstimatedAvailableDegreeOfParallelism="6" MaxCompileMemory="17544600"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2026-10-03T15:35:13.52" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000002_04E4BC85]" Table="[catalog_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:35:12.33" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000E_04E4BC85]" Table="[catalog_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:35:13.88" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000009_71D1E811]" Table="[warehouse]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:35:08.10" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000001_72C60C4A]" Table="[ship_mode]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:35:10.58" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000002_03F0984C]" Table="[web_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:35:14.03" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_0000000A_71D1E811]" Table="[warehouse]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:35:10.90" ModificationCount="0" SamplingPercent="69.1329" Statistics="[_WA_Sys_00000003_73BA3083]" Table="[time_dim]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:34:56.59" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_0000000B_71D1E811]" Table="[warehouse]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:35:07.92" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000F_03F0984C]" Table="[web_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:04.43" ModificationCount="0" SamplingPercent="73.9837" Statistics="[_WA_Sys_00000001_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:34:29.76" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000003_71D1E811]" Table="[warehouse]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:31:25.34" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_03F0984C]" Table="[web_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:34:01.13" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_0000000F_04E4BC85]" Table="[catalog_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:34:23.96" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000001_71D1E811]" Table="[warehouse]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:35:14.18" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_0000000D_71D1E811]" Table="[warehouse]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:31:26.42" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000001_04E4BC85]" Table="[catalog_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:41.07" ModificationCount="0" SamplingPercent="10" Statistics="[_WA_Sys_00000010_03F0984C]" Table="[web_sales]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:35:13.73" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000004_71D1E811]" Table="[warehouse]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:35:11.33" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000005_72C60C4A]" Table="[ship_mode]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:24:04.19" ModificationCount="0" SamplingPercent="73.9587" Statistics="[_WA_Sys_00000007_70DDC3D8]" Table="[date_dim]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-03T15:35:11.14" ModificationCount="0" SamplingPercent="69.1757" Statistics="[_WA_Sys_00000001_73BA3083]" Table="[time_dim]" Schema="[dbo]" Database="[TPCDS_SF100]"></StatisticsInfo></OptimizerStatsUsage><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="22.5" EstimateIO="0" EstimateCPU="2.25e-06" AvgRowSize="725" EstimatedTotalSubtreeCost="178.742" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1070"></ColumnReference><ColumnReference Column="Union1071"></ColumnReference><ColumnReference Column="Union1072"></ColumnReference><ColumnReference Column="Union1073"></ColumnReference><ColumnReference Column="Union1074"></ColumnReference><ColumnReference Column="Union1075"></ColumnReference><ColumnReference Column="Union1076"></ColumnReference><ColumnReference Column="Union1077"></ColumnReference><ColumnReference Column="Expr1102"></ColumnReference><ColumnReference Column="Expr1103"></ColumnReference><ColumnReference Column="Expr1104"></ColumnReference><ColumnReference Column="Expr1105"></ColumnReference><ColumnReference Column="Expr1106"></ColumnReference><ColumnReference Column="Expr1107"></ColumnReference><ColumnReference Column="Expr1108"></ColumnReference><ColumnReference Column="Expr1109"></ColumnReference><ColumnReference Column="Expr1110"></ColumnReference><ColumnReference Column="Expr1111"></ColumnReference><ColumnReference Column="Expr1112"></ColumnReference><ColumnReference Column="Expr1113"></ColumnReference><ColumnReference Column="Expr1114"></ColumnReference><ColumnReference Column="Expr1115"></ColumnReference><ColumnReference Column="Expr1116"></ColumnReference><ColumnReference Column="Expr1117"></ColumnReference><ColumnReference Column="Expr1118"></ColumnReference><ColumnReference Column="Expr1119"></ColumnReference><ColumnReference Column="Expr1120"></ColumnReference><ColumnReference Column="Expr1121"></ColumnReference><ColumnReference Column="Expr1122"></ColumnReference><ColumnReference Column="Expr1123"></ColumnReference><ColumnReference Column="Expr1124"></ColumnReference><ColumnReference Column="Expr1125"></ColumnReference><ColumnReference Column="Expr1126"></ColumnReference><ColumnReference Column="Expr1127"></ColumnReference><ColumnReference Column="Expr1128"></ColumnReference><ColumnReference Column="Expr1129"></ColumnReference><ColumnReference Column="Expr1130"></ColumnReference><ColumnReference Column="Expr1131"></ColumnReference><ColumnReference Column="Expr1132"></ColumnReference><ColumnReference Column="Expr1133"></ColumnReference><ColumnReference Column="Expr1134"></ColumnReference><ColumnReference Column="Expr1135"></ColumnReference><ColumnReference Column="Expr1136"></ColumnReference><ColumnReference Column="Expr1137"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Union1070"></ColumnReference><ScalarOperator ScalarString="[Union1070]"><Identifier><ColumnReference Column="Union1070"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Union1071"></ColumnReference><ScalarOperator ScalarString="[Union1071]"><Identifier><ColumnReference Column="Union1071"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Union1072"></ColumnReference><ScalarOperator ScalarString="[Union1072]"><Identifier><ColumnReference Column="Union1072"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Union1073"></ColumnReference><ScalarOperator ScalarString="[Union1073]"><Identifier><ColumnReference Column="Union1073"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Union1074"></ColumnReference><ScalarOperator ScalarString="[Union1074]"><Identifier><ColumnReference Column="Union1074"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Union1075"></ColumnReference><ScalarOperator ScalarString="[Union1075]"><Identifier><ColumnReference Column="Union1075"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Union1076"></ColumnReference><ScalarOperator ScalarString="[Union1076]"><Identifier><ColumnReference Column="Union1076"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Union1077"></ColumnReference><ScalarOperator ScalarString="[Union1077]"><Identifier><ColumnReference Column="Union1077"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1102"></ColumnReference><ScalarOperator ScalarString="[Expr1102]"><Identifier><ColumnReference Column="Expr1102"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1103"></ColumnReference><ScalarOperator ScalarString="[Expr1103]"><Identifier><ColumnReference Column="Expr1103"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1104"></ColumnReference><ScalarOperator ScalarString="[Expr1104]"><Identifier><ColumnReference Column="Expr1104"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1105"></ColumnReference><ScalarOperator ScalarString="[Expr1105]"><Identifier><ColumnReference Column="Expr1105"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1106"></ColumnReference><ScalarOperator ScalarString="[Expr1106]"><Identifier><ColumnReference Column="Expr1106"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1107"></ColumnReference><ScalarOperator ScalarString="[Expr1107]"><Identifier><ColumnReference Column="Expr1107"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1108"></ColumnReference><ScalarOperator ScalarString="[Expr1108]"><Identifier><ColumnReference Column="Expr1108"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1109"></ColumnReference><ScalarOperator ScalarString="[Expr1109]"><Identifier><ColumnReference Column="Expr1109"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1110"></ColumnReference><ScalarOperator ScalarString="[Expr1110]"><Identifier><ColumnReference Column="Expr1110"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1111"></ColumnReference><ScalarOperator ScalarString="[Expr1111]"><Identifier><ColumnReference Column="Expr1111"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1112"></ColumnReference><ScalarOperator ScalarString="[Expr1112]"><Identifier><ColumnReference Column="Expr1112"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1113"></ColumnReference><ScalarOperator ScalarString="[Expr1113]"><Identifier><ColumnReference Column="Expr1113"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1114"></ColumnReference><ScalarOperator ScalarString="[Expr1114]"><Identifier><ColumnReference Column="Expr1114"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1115"></ColumnReference><ScalarOperator ScalarString="[Expr1115]"><Identifier><ColumnReference Column="Expr1115"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1116"></ColumnReference><ScalarOperator ScalarString="[Expr1116]"><Identifier><ColumnReference Column="Expr1116"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1117"></ColumnReference><ScalarOperator ScalarString="[Expr1117]"><Identifier><ColumnReference Column="Expr1117"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1118"></ColumnReference><ScalarOperator ScalarString="[Expr1118]"><Identifier><ColumnReference Column="Expr1118"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1119"></ColumnReference><ScalarOperator ScalarString="[Expr1119]"><Identifier><ColumnReference Column="Expr1119"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1120"></ColumnReference><ScalarOperator ScalarString="[Expr1120]"><Identifier><ColumnReference Column="Expr1120"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1121"></ColumnReference><ScalarOperator ScalarString="[Expr1121]"><Identifier><ColumnReference Column="Expr1121"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1122"></ColumnReference><ScalarOperator ScalarString="[Expr1122]"><Identifier><ColumnReference Column="Expr1122"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1123"></ColumnReference><ScalarOperator ScalarString="[Expr1123]"><Identifier><ColumnReference Column="Expr1123"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1124"></ColumnReference><ScalarOperator ScalarString="[Expr1124]"><Identifier><ColumnReference Column="Expr1124"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1125"></ColumnReference><ScalarOperator ScalarString="[Expr1125]"><Identifier><ColumnReference Column="Expr1125"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1126"></ColumnReference><ScalarOperator ScalarString="[Expr1126]"><Identifier><ColumnReference Column="Expr1126"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1127"></ColumnReference><ScalarOperator ScalarString="[Expr1127]"><Identifier><ColumnReference Column="Expr1127"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1128"></ColumnReference><ScalarOperator ScalarString="[Expr1128]"><Identifier><ColumnReference Column="Expr1128"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1129"></ColumnReference><ScalarOperator ScalarString="[Expr1129]"><Identifier><ColumnReference Column="Expr1129"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1130"></ColumnReference><ScalarOperator ScalarString="[Expr1130]"><Identifier><ColumnReference Column="Expr1130"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1131"></ColumnReference><ScalarOperator ScalarString="[Expr1131]"><Identifier><ColumnReference Column="Expr1131"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1132"></ColumnReference><ScalarOperator ScalarString="[Expr1132]"><Identifier><ColumnReference Column="Expr1132"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1133"></ColumnReference><ScalarOperator ScalarString="[Expr1133]"><Identifier><ColumnReference Column="Expr1133"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1134"></ColumnReference><ScalarOperator ScalarString="[Expr1134]"><Identifier><ColumnReference Column="Expr1134"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1135"></ColumnReference><ScalarOperator ScalarString="[Expr1135]"><Identifier><ColumnReference Column="Expr1135"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1136"></ColumnReference><ScalarOperator ScalarString="[Expr1136]"><Identifier><ColumnReference Column="Expr1136"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1137"></ColumnReference><ScalarOperator ScalarString="[Expr1137]"><Identifier><ColumnReference Column="Expr1137"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Compute To Control Node" LogicalOp="Move" EstimateRows="22.5" EstimateIO="0" EstimateCPU="2.25e-06" AvgRowSize="725" EstimatedTotalSubtreeCost="178.742" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1070"></ColumnReference><ColumnReference Column="Union1071"></ColumnReference><ColumnReference Column="Union1072"></ColumnReference><ColumnReference Column="Union1073"></ColumnReference><ColumnReference Column="Union1074"></ColumnReference><ColumnReference Column="Union1075"></ColumnReference><ColumnReference Column="Union1076"></ColumnReference><ColumnReference Column="Union1077"></ColumnReference><ColumnReference Column="Expr1102"></ColumnReference><ColumnReference Column="Expr1103"></ColumnReference><ColumnReference Column="Expr1104"></ColumnReference><ColumnReference Column="Expr1105"></ColumnReference><ColumnReference Column="Expr1106"></ColumnReference><ColumnReference Column="Expr1107"></ColumnReference><ColumnReference Column="Expr1108"></ColumnReference><ColumnReference Column="Expr1109"></ColumnReference><ColumnReference Column="Expr1110"></ColumnReference><ColumnReference Column="Expr1111"></ColumnReference><ColumnReference Column="Expr1112"></ColumnReference><ColumnReference Column="Expr1113"></ColumnReference><ColumnReference Column="Expr1114"></ColumnReference><ColumnReference Column="Expr1115"></ColumnReference><ColumnReference Column="Expr1116"></ColumnReference><ColumnReference Column="Expr1117"></ColumnReference><ColumnReference Column="Expr1118"></ColumnReference><ColumnReference Column="Expr1119"></ColumnReference><ColumnReference Column="Expr1120"></ColumnReference><ColumnReference Column="Expr1121"></ColumnReference><ColumnReference Column="Expr1122"></ColumnReference><ColumnReference Column="Expr1123"></ColumnReference><ColumnReference Column="Expr1124"></ColumnReference><ColumnReference Column="Expr1125"></ColumnReference><ColumnReference Column="Expr1126"></ColumnReference><ColumnReference Column="Expr1127"></ColumnReference><ColumnReference Column="Expr1128"></ColumnReference><ColumnReference Column="Expr1129"></ColumnReference><ColumnReference Column="Expr1130"></ColumnReference><ColumnReference Column="Expr1131"></ColumnReference><ColumnReference Column="Expr1132"></ColumnReference><ColumnReference Column="Expr1133"></ColumnReference><ColumnReference Column="Expr1134"></ColumnReference><ColumnReference Column="Expr1135"></ColumnReference><ColumnReference Column="Expr1136"></ColumnReference><ColumnReference Column="Expr1137"></ColumnReference></OutputList><Move DistributionType="Return" MoveTopology="OneToOne"><RelOp NodeId="3" PhysicalOp="Sort" LogicalOp="TopN Sort" EstimateRows="22.5" EstimateIO="0.00563063" EstimateCPU="0.000174737" AvgRowSize="725" EstimatedTotalSubtreeCost="178.742" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1070"></ColumnReference><ColumnReference Column="Union1071"></ColumnReference><ColumnReference Column="Union1072"></ColumnReference><ColumnReference Column="Union1073"></ColumnReference><ColumnReference Column="Union1074"></ColumnReference><ColumnReference Column="Union1075"></ColumnReference><ColumnReference Column="Union1076"></ColumnReference><ColumnReference Column="Union1077"></ColumnReference><ColumnReference Column="Expr1102"></ColumnReference><ColumnReference Column="Expr1103"></ColumnReference><ColumnReference Column="Expr1104"></ColumnReference><ColumnReference Column="Expr1105"></ColumnReference><ColumnReference Column="Expr1106"></ColumnReference><ColumnReference Column="Expr1107"></ColumnReference><ColumnReference Column="Expr1108"></ColumnReference><ColumnReference Column="Expr1109"></ColumnReference><ColumnReference Column="Expr1110"></ColumnReference><ColumnReference Column="Expr1111"></ColumnReference><ColumnReference Column="Expr1112"></ColumnReference><ColumnReference Column="Expr1113"></ColumnReference><ColumnReference Column="Expr1114"></ColumnReference><ColumnReference Column="Expr1115"></ColumnReference><ColumnReference Column="Expr1116"></ColumnReference><ColumnReference Column="Expr1117"></ColumnReference><ColumnReference Column="Expr1118"></ColumnReference><ColumnReference Column="Expr1119"></ColumnReference><ColumnReference Column="Expr1120"></ColumnReference><ColumnReference Column="Expr1121"></ColumnReference><ColumnReference Column="Expr1122"></ColumnReference><ColumnReference Column="Expr1123"></ColumnReference><ColumnReference Column="Expr1124"></ColumnReference><ColumnReference Column="Expr1125"></ColumnReference><ColumnReference Column="Expr1126"></ColumnReference><ColumnReference Column="Expr1127"></ColumnReference><ColumnReference Column="Expr1128"></ColumnReference><ColumnReference Column="Expr1129"></ColumnReference><ColumnReference Column="Expr1130"></ColumnReference><ColumnReference Column="Expr1131"></ColumnReference><ColumnReference Column="Expr1132"></ColumnReference><ColumnReference Column="Expr1133"></ColumnReference><ColumnReference Column="Expr1134"></ColumnReference><ColumnReference Column="Expr1135"></ColumnReference><ColumnReference Column="Expr1136"></ColumnReference><ColumnReference Column="Expr1137"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><TopSort Distinct="0" Rows="100"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Column="Union1070"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="4" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="22.5" EstimateIO="0" EstimateCPU="0" AvgRowSize="725" EstimatedTotalSubtreeCost="178.736" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1070"></ColumnReference><ColumnReference Column="Union1071"></ColumnReference><ColumnReference Column="Union1072"></ColumnReference><ColumnReference Column="Union1073"></ColumnReference><ColumnReference Column="Union1074"></ColumnReference><ColumnReference Column="Union1075"></ColumnReference><ColumnReference Column="Union1076"></ColumnReference><ColumnReference Column="Union1077"></ColumnReference><ColumnReference Column="Expr1102"></ColumnReference><ColumnReference Column="Expr1103"></ColumnReference><ColumnReference Column="Expr1104"></ColumnReference><ColumnReference Column="Expr1105"></ColumnReference><ColumnReference Column="Expr1106"></ColumnReference><ColumnReference Column="Expr1107"></ColumnReference><ColumnReference Column="Expr1108"></ColumnReference><ColumnReference Column="Expr1109"></ColumnReference><ColumnReference Column="Expr1110"></ColumnReference><ColumnReference Column="Expr1111"></ColumnReference><ColumnReference Column="Expr1112"></ColumnReference><ColumnReference Column="Expr1113"></ColumnReference><ColumnReference Column="Expr1114"></ColumnReference><ColumnReference Column="Expr1115"></ColumnReference><ColumnReference Column="Expr1116"></ColumnReference><ColumnReference Column="Expr1117"></ColumnReference><ColumnReference Column="Expr1118"></ColumnReference><ColumnReference Column="Expr1119"></ColumnReference><ColumnReference Column="Expr1120"></ColumnReference><ColumnReference Column="Expr1121"></ColumnReference><ColumnReference Column="Expr1122"></ColumnReference><ColumnReference Column="Expr1123"></ColumnReference><ColumnReference Column="Expr1124"></ColumnReference><ColumnReference Column="Expr1125"></ColumnReference><ColumnReference Column="Expr1126"></ColumnReference><ColumnReference Column="Expr1127"></ColumnReference><ColumnReference Column="Expr1128"></ColumnReference><ColumnReference Column="Expr1129"></ColumnReference><ColumnReference Column="Expr1130"></ColumnReference><ColumnReference Column="Expr1131"></ColumnReference><ColumnReference Column="Expr1132"></ColumnReference><ColumnReference Column="Expr1133"></ColumnReference><ColumnReference Column="Expr1134"></ColumnReference><ColumnReference Column="Expr1135"></ColumnReference><ColumnReference Column="Expr1136"></ColumnReference><ColumnReference Column="Expr1137"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1102"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1472]=(0) THEN NULL ELSE [Expr1473] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1472"></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="Expr1473"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1103"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1474]=(0) THEN NULL ELSE [Expr1475] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1474"></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="Expr1475"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1104"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1476]=(0) THEN NULL ELSE [Expr1477] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1476"></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="Expr1477"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1105"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1478]=(0) THEN NULL ELSE [Expr1479] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1478"></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="Expr1479"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1106"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1480]=(0) THEN NULL ELSE [Expr1481] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1480"></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="Expr1481"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1107"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1482]=(0) THEN NULL ELSE [Expr1483] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1482"></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="Expr1483"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1108"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1484]=(0) THEN NULL ELSE [Expr1485] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1484"></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="Expr1485"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1109"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1486]=(0) THEN NULL ELSE [Expr1487] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1486"></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="Expr1487"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1110"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1488]=(0) THEN NULL ELSE [Expr1489] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1488"></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="Expr1489"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1111"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1490]=(0) THEN NULL ELSE [Expr1491] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1490"></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="Expr1491"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1112"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1492]=(0) THEN NULL ELSE [Expr1493] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1492"></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="Expr1493"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1113"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1494]=(0) THEN NULL ELSE [Expr1495] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1494"></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="Expr1495"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1114"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1496]=(0) THEN NULL ELSE [Expr1497] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1496"></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="Expr1497"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1115"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1498]=(0) THEN NULL ELSE [Expr1499] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1498"></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="Expr1499"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1116"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1500]=(0) THEN NULL ELSE [Expr1501] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1500"></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="Expr1501"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1117"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1502]=(0) THEN NULL ELSE [Expr1503] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1502"></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="Expr1503"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1118"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1504]=(0) THEN NULL ELSE [Expr1505] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1504"></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="Expr1505"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1119"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1506]=(0) THEN NULL ELSE [Expr1507] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1506"></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="Expr1507"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1120"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1508]=(0) THEN NULL ELSE [Expr1509] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1508"></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="Expr1509"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1121"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1510]=(0) THEN NULL ELSE [Expr1511] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1510"></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="Expr1511"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1122"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1512]=(0) THEN NULL ELSE [Expr1513] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1512"></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="Expr1513"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1123"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1514]=(0) THEN NULL ELSE [Expr1515] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1514"></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="Expr1515"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1124"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1516]=(0) THEN NULL ELSE [Expr1517] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1516"></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="Expr1517"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1125"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1518]=(0) THEN NULL ELSE [Expr1519] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1518"></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="Expr1519"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1126"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1520]=(0) THEN NULL ELSE [Expr1521] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1520"></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="Expr1521"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1127"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1522]=(0) THEN NULL ELSE [Expr1523] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1522"></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="Expr1523"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1128"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1524]=(0) THEN NULL ELSE [Expr1525] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1524"></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="Expr1525"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1129"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1526]=(0) THEN NULL ELSE [Expr1527] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1526"></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="Expr1527"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1130"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1528]=(0) THEN NULL ELSE [Expr1529] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1528"></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="Expr1529"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1131"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1530]=(0) THEN NULL ELSE [Expr1531] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1530"></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="Expr1531"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1132"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1532]=(0) THEN NULL ELSE [Expr1533] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1532"></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="Expr1533"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1133"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1534]=(0) THEN NULL ELSE [Expr1535] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1534"></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="Expr1535"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1134"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1536]=(0) THEN NULL ELSE [Expr1537] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1536"></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="Expr1537"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1135"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1538]=(0) THEN NULL ELSE [Expr1539] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1538"></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="Expr1539"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1136"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1540]=(0) THEN NULL ELSE [Expr1541] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1540"></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="Expr1541"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1137"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1542]=(0) THEN NULL ELSE [Expr1543] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1542"></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="Expr1543"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="5" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="22.5" EstimateIO="0" EstimateCPU="0.00293638" AvgRowSize="725" EstimatedTotalSubtreeCost="178.736" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1070"></ColumnReference><ColumnReference Column="Union1071"></ColumnReference><ColumnReference Column="Union1072"></ColumnReference><ColumnReference Column="Union1073"></ColumnReference><ColumnReference Column="Union1074"></ColumnReference><ColumnReference Column="Union1075"></ColumnReference><ColumnReference Column="Union1076"></ColumnReference><ColumnReference Column="Union1077"></ColumnReference><ColumnReference Column="Expr1472"></ColumnReference><ColumnReference Column="Expr1473"></ColumnReference><ColumnReference Column="Expr1474"></ColumnReference><ColumnReference Column="Expr1475"></ColumnReference><ColumnReference Column="Expr1476"></ColumnReference><ColumnReference Column="Expr1477"></ColumnReference><ColumnReference Column="Expr1478"></ColumnReference><ColumnReference Column="Expr1479"></ColumnReference><ColumnReference Column="Expr1480"></ColumnReference><ColumnReference Column="Expr1481"></ColumnReference><ColumnReference Column="Expr1482"></ColumnReference><ColumnReference Column="Expr1483"></ColumnReference><ColumnReference Column="Expr1484"></ColumnReference><ColumnReference Column="Expr1485"></ColumnReference><ColumnReference Column="Expr1486"></ColumnReference><ColumnReference Column="Expr1487"></ColumnReference><ColumnReference Column="Expr1488"></ColumnReference><ColumnReference Column="Expr1489"></ColumnReference><ColumnReference Column="Expr1490"></ColumnReference><ColumnReference Column="Expr1491"></ColumnReference><ColumnReference Column="Expr1492"></ColumnReference><ColumnReference Column="Expr1493"></ColumnReference><ColumnReference Column="Expr1494"></ColumnReference><ColumnReference Column="Expr1495"></ColumnReference><ColumnReference Column="Expr1496"></ColumnReference><ColumnReference Column="Expr1497"></ColumnReference><ColumnReference Column="Expr1498"></ColumnReference><ColumnReference Column="Expr1499"></ColumnReference><ColumnReference Column="Expr1500"></ColumnReference><ColumnReference Column="Expr1501"></ColumnReference><ColumnReference Column="Expr1502"></ColumnReference><ColumnReference Column="Expr1503"></ColumnReference><ColumnReference Column="Expr1504"></ColumnReference><ColumnReference Column="Expr1505"></ColumnReference><ColumnReference Column="Expr1506"></ColumnReference><ColumnReference Column="Expr1507"></ColumnReference><ColumnReference Column="Expr1508"></ColumnReference><ColumnReference Column="Expr1509"></ColumnReference><ColumnReference Column="Expr1510"></ColumnReference><ColumnReference Column="Expr1511"></ColumnReference><ColumnReference Column="Expr1512"></ColumnReference><ColumnReference Column="Expr1513"></ColumnReference><ColumnReference Column="Expr1514"></ColumnReference><ColumnReference Column="Expr1515"></ColumnReference><ColumnReference Column="Expr1516"></ColumnReference><ColumnReference Column="Expr1517"></ColumnReference><ColumnReference Column="Expr1518"></ColumnReference><ColumnReference Column="Expr1519"></ColumnReference><ColumnReference Column="Expr1520"></ColumnReference><ColumnReference Column="Expr1521"></ColumnReference><ColumnReference Column="Expr1522"></ColumnReference><ColumnReference Column="Expr1523"></ColumnReference><ColumnReference Column="Expr1524"></ColumnReference><ColumnReference Column="Expr1525"></ColumnReference><ColumnReference Column="Expr1526"></ColumnReference><ColumnReference Column="Expr1527"></ColumnReference><ColumnReference Column="Expr1528"></ColumnReference><ColumnReference Column="Expr1529"></ColumnReference><ColumnReference Column="Expr1530"></ColumnReference><ColumnReference Column="Expr1531"></ColumnReference><ColumnReference Column="Expr1532"></ColumnReference><ColumnReference Column="Expr1533"></ColumnReference><ColumnReference Column="Expr1534"></ColumnReference><ColumnReference Column="Expr1535"></ColumnReference><ColumnReference Column="Expr1536"></ColumnReference><ColumnReference Column="Expr1537"></ColumnReference><ColumnReference Column="Expr1538"></ColumnReference><ColumnReference Column="Expr1539"></ColumnReference><ColumnReference Column="Expr1540"></ColumnReference><ColumnReference Column="Expr1541"></ColumnReference><ColumnReference Column="Expr1542"></ColumnReference><ColumnReference Column="Expr1543"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1472"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1078])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1078"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1473"></ColumnReference><ScalarOperator ScalarString="SUM([Union1078])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1078"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1474"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1079])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1079"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1475"></ColumnReference><ScalarOperator ScalarString="SUM([Union1079])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1079"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1476"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1080])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1080"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1477"></ColumnReference><ScalarOperator ScalarString="SUM([Union1080])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1080"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1478"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1081])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1081"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1479"></ColumnReference><ScalarOperator ScalarString="SUM([Union1081])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1081"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1480"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1082])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1082"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1481"></ColumnReference><ScalarOperator ScalarString="SUM([Union1082])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1082"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1482"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1083])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1083"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1483"></ColumnReference><ScalarOperator ScalarString="SUM([Union1083])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1083"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1484"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1084])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1084"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1485"></ColumnReference><ScalarOperator ScalarString="SUM([Union1084])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1084"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1486"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1085])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1085"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1487"></ColumnReference><ScalarOperator ScalarString="SUM([Union1085])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1085"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1488"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1086])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1086"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1489"></ColumnReference><ScalarOperator ScalarString="SUM([Union1086])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1086"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1490"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1087])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1087"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1491"></ColumnReference><ScalarOperator ScalarString="SUM([Union1087])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1087"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1492"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1088])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1088"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1493"></ColumnReference><ScalarOperator ScalarString="SUM([Union1088])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1088"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1494"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1089])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1089"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1495"></ColumnReference><ScalarOperator ScalarString="SUM([Union1089])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1089"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1496"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1364])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1364"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1497"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1364])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1364"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1498"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1365])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1365"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1499"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1365])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1365"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1500"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1366])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1366"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1501"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1366])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1366"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1502"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1367])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1367"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1503"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1367])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1367"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1504"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1368])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1368"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1505"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1368])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1368"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1506"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1369])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1369"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1507"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1369])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1369"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1508"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1370])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1370"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1509"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1370])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1370"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1510"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1371])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1371"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1511"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1371])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1371"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1512"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1372])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1372"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1513"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1372])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1372"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1514"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1373])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1373"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1515"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1373])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1373"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1516"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1374])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1374"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1517"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1374])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1374"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1518"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1375])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1375"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1519"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1375])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1375"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1520"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1090])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1090"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1521"></ColumnReference><ScalarOperator ScalarString="SUM([Union1090])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1090"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1522"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1091])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1091"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1523"></ColumnReference><ScalarOperator ScalarString="SUM([Union1091])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1091"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1524"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1092])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1092"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1525"></ColumnReference><ScalarOperator ScalarString="SUM([Union1092])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1092"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1526"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1093])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1093"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1527"></ColumnReference><ScalarOperator ScalarString="SUM([Union1093])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1093"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1528"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1094])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1094"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1529"></ColumnReference><ScalarOperator ScalarString="SUM([Union1094])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1094"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1530"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1095])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1095"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1531"></ColumnReference><ScalarOperator ScalarString="SUM([Union1095])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1095"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1532"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1096])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1096"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1533"></ColumnReference><ScalarOperator ScalarString="SUM([Union1096])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1096"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1534"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1097])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1097"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1535"></ColumnReference><ScalarOperator ScalarString="SUM([Union1097])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1097"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1536"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1098])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1098"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1537"></ColumnReference><ScalarOperator ScalarString="SUM([Union1098])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1098"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1538"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1099])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1099"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1539"></ColumnReference><ScalarOperator ScalarString="SUM([Union1099])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1099"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1540"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1100])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1100"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1541"></ColumnReference><ScalarOperator ScalarString="SUM([Union1100])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1100"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1542"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Union1101])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Union1101"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1543"></ColumnReference><ScalarOperator ScalarString="SUM([Union1101])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Union1101"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Union1076"></ColumnReference><ScalarOperator ScalarString="ANY([Union1076])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Union1076"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Union1077"></ColumnReference><ScalarOperator ScalarString="ANY([Union1077])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Union1077"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Column="Union1070"></ColumnReference><ColumnReference Column="Union1071"></ColumnReference><ColumnReference Column="Union1072"></ColumnReference><ColumnReference Column="Union1073"></ColumnReference><ColumnReference Column="Union1074"></ColumnReference><ColumnReference Column="Union1075"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[Union1070] = [Union1070] AND [Union1071] = [Union1071] AND [Union1072] = [Union1072] AND [Union1073] = [Union1073] AND [Union1074] = [Union1074] AND [Union1075] = [Union1075]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Union1070"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1070"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Union1071"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1071"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Union1072"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1072"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Union1073"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1073"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Union1074"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1074"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Union1075"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1075"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="6" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="30" EstimateIO="0" EstimateCPU="3e-07" AvgRowSize="725" EstimatedTotalSubtreeCost="178.733" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1070"></ColumnReference><ColumnReference Column="Union1071"></ColumnReference><ColumnReference Column="Union1072"></ColumnReference><ColumnReference Column="Union1073"></ColumnReference><ColumnReference Column="Union1074"></ColumnReference><ColumnReference Column="Union1075"></ColumnReference><ColumnReference Column="Union1076"></ColumnReference><ColumnReference Column="Union1077"></ColumnReference><ColumnReference Column="Union1078"></ColumnReference><ColumnReference Column="Union1079"></ColumnReference><ColumnReference Column="Union1080"></ColumnReference><ColumnReference Column="Union1081"></ColumnReference><ColumnReference Column="Union1082"></ColumnReference><ColumnReference Column="Union1083"></ColumnReference><ColumnReference Column="Union1084"></ColumnReference><ColumnReference Column="Union1085"></ColumnReference><ColumnReference Column="Union1086"></ColumnReference><ColumnReference Column="Union1087"></ColumnReference><ColumnReference Column="Union1088"></ColumnReference><ColumnReference Column="Union1089"></ColumnReference><ColumnReference Column="Union1090"></ColumnReference><ColumnReference Column="Union1091"></ColumnReference><ColumnReference Column="Union1092"></ColumnReference><ColumnReference Column="Union1093"></ColumnReference><ColumnReference Column="Union1094"></ColumnReference><ColumnReference Column="Union1095"></ColumnReference><ColumnReference Column="Union1096"></ColumnReference><ColumnReference Column="Union1097"></ColumnReference><ColumnReference Column="Union1098"></ColumnReference><ColumnReference Column="Union1099"></ColumnReference><ColumnReference Column="Union1100"></ColumnReference><ColumnReference Column="Union1101"></ColumnReference><ColumnReference Column="Expr1364"></ColumnReference><ColumnReference Column="Expr1365"></ColumnReference><ColumnReference Column="Expr1366"></ColumnReference><ColumnReference Column="Expr1367"></ColumnReference><ColumnReference Column="Expr1368"></ColumnReference><ColumnReference Column="Expr1369"></ColumnReference><ColumnReference Column="Expr1370"></ColumnReference><ColumnReference Column="Expr1371"></ColumnReference><ColumnReference Column="Expr1372"></ColumnReference><ColumnReference Column="Expr1373"></ColumnReference><ColumnReference Column="Expr1374"></ColumnReference><ColumnReference Column="Expr1375"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1364"></ColumnReference><ScalarOperator ScalarString="[Union1078]/CONVERT_IMPLICIT(decimal(10,0),[Union1071],0)"><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Union1078"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Union1071"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1365"></ColumnReference><ScalarOperator ScalarString="[Union1079]/CONVERT_IMPLICIT(decimal(10,0),[Union1071],0)"><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Union1079"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Union1071"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1366"></ColumnReference><ScalarOperator ScalarString="[Union1080]/CONVERT_IMPLICIT(decimal(10,0),[Union1071],0)"><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Union1080"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Union1071"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1367"></ColumnReference><ScalarOperator ScalarString="[Union1081]/CONVERT_IMPLICIT(decimal(10,0),[Union1071],0)"><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Union1081"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Union1071"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1368"></ColumnReference><ScalarOperator ScalarString="[Union1082]/CONVERT_IMPLICIT(decimal(10,0),[Union1071],0)"><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Union1082"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Union1071"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1369"></ColumnReference><ScalarOperator ScalarString="[Union1083]/CONVERT_IMPLICIT(decimal(10,0),[Union1071],0)"><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Union1083"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Union1071"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1370"></ColumnReference><ScalarOperator ScalarString="[Union1084]/CONVERT_IMPLICIT(decimal(10,0),[Union1071],0)"><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Union1084"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Union1071"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1371"></ColumnReference><ScalarOperator ScalarString="[Union1085]/CONVERT_IMPLICIT(decimal(10,0),[Union1071],0)"><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Union1085"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Union1071"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1372"></ColumnReference><ScalarOperator ScalarString="[Union1086]/CONVERT_IMPLICIT(decimal(10,0),[Union1071],0)"><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Union1086"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Union1071"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1373"></ColumnReference><ScalarOperator ScalarString="[Union1087]/CONVERT_IMPLICIT(decimal(10,0),[Union1071],0)"><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Union1087"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Union1071"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1374"></ColumnReference><ScalarOperator ScalarString="[Union1088]/CONVERT_IMPLICIT(decimal(10,0),[Union1071],0)"><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Union1088"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Union1071"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1375"></ColumnReference><ScalarOperator ScalarString="[Union1089]/CONVERT_IMPLICIT(decimal(10,0),[Union1071],0)"><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Column="Union1089"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Union1071"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="7" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="30" EstimateIO="0" EstimateCPU="3e-07" AvgRowSize="519" EstimatedTotalSubtreeCost="178.733" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Union1070"></ColumnReference><ColumnReference Column="Union1071"></ColumnReference><ColumnReference Column="Union1072"></ColumnReference><ColumnReference Column="Union1073"></ColumnReference><ColumnReference Column="Union1074"></ColumnReference><ColumnReference Column="Union1075"></ColumnReference><ColumnReference Column="Union1076"></ColumnReference><ColumnReference Column="Union1077"></ColumnReference><ColumnReference Column="Union1078"></ColumnReference><ColumnReference Column="Union1079"></ColumnReference><ColumnReference Column="Union1080"></ColumnReference><ColumnReference Column="Union1081"></ColumnReference><ColumnReference Column="Union1082"></ColumnReference><ColumnReference Column="Union1083"></ColumnReference><ColumnReference Column="Union1084"></ColumnReference><ColumnReference Column="Union1085"></ColumnReference><ColumnReference Column="Union1086"></ColumnReference><ColumnReference Column="Union1087"></ColumnReference><ColumnReference Column="Union1088"></ColumnReference><ColumnReference Column="Union1089"></ColumnReference><ColumnReference Column="Union1090"></ColumnReference><ColumnReference Column="Union1091"></ColumnReference><ColumnReference Column="Union1092"></ColumnReference><ColumnReference Column="Union1093"></ColumnReference><ColumnReference Column="Union1094"></ColumnReference><ColumnReference Column="Union1095"></ColumnReference><ColumnReference Column="Union1096"></ColumnReference><ColumnReference Column="Union1097"></ColumnReference><ColumnReference Column="Union1098"></ColumnReference><ColumnReference Column="Union1099"></ColumnReference><ColumnReference Column="Union1100"></ColumnReference><ColumnReference Column="Union1101"></ColumnReference></OutputList><Concat><DefinedValues><DefinedValue><ColumnReference Column="Union1070"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1071"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sq_ft"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sq_ft"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1072"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_city"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_city"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1073"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_county"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_county"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1074"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_state"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_state"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1075"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_country"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1076"></ColumnReference><ColumnReference Column="Expr1034"></ColumnReference><ColumnReference Column="Expr1069"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1077"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1078"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="Expr1045"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1079"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference><ColumnReference Column="Expr1046"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1080"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1047"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1081"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="Expr1048"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1082"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="Expr1049"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1083"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1050"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1084"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1051"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1085"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1052"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1086"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1053"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1087"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1054"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1088"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1055"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1089"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference><ColumnReference Column="Expr1056"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1090"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference><ColumnReference Column="Expr1057"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1091"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1058"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1092"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1059"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1093"></ColumnReference><ColumnReference Column="Expr1025"></ColumnReference><ColumnReference Column="Expr1060"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1094"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1061"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1095"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference><ColumnReference Column="Expr1062"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1096"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference><ColumnReference Column="Expr1063"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1097"></ColumnReference><ColumnReference Column="Expr1029"></ColumnReference><ColumnReference Column="Expr1064"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1098"></ColumnReference><ColumnReference Column="Expr1030"></ColumnReference><ColumnReference Column="Expr1065"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1099"></ColumnReference><ColumnReference Column="Expr1031"></ColumnReference><ColumnReference Column="Expr1066"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1100"></ColumnReference><ColumnReference Column="Expr1032"></ColumnReference><ColumnReference Column="Expr1067"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1101"></ColumnReference><ColumnReference Column="Expr1033"></ColumnReference><ColumnReference Column="Expr1068"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="8" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="15" EstimateIO="0" EstimateCPU="1.5e-07" AvgRowSize="519" EstimatedTotalSubtreeCost="59.5755" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sq_ft"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_city"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_county"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_state"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1025"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference><ColumnReference Column="Expr1029"></ColumnReference><ColumnReference Column="Expr1030"></ColumnReference><ColumnReference Column="Expr1031"></ColumnReference><ColumnReference Column="Expr1032"></ColumnReference><ColumnReference Column="Expr1033"></ColumnReference><ColumnReference Column="Expr1034"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1034"></ColumnReference><ScalarOperator ScalarString="&apos;BARIAN,ORIENTAL&apos;"><Const ConstValue="&apos;BARIAN,ORIENTAL&apos;"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="9" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="15" EstimateIO="0" EstimateCPU="0" AvgRowSize="510" EstimatedTotalSubtreeCost="59.5755" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sq_ft"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_city"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_county"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_state"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1025"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference><ColumnReference Column="Expr1029"></ColumnReference><ColumnReference Column="Expr1030"></ColumnReference><ColumnReference Column="Expr1031"></ColumnReference><ColumnReference Column="Expr1032"></ColumnReference><ColumnReference Column="Expr1033"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1010"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1376]=(0) THEN NULL ELSE [Expr1377] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1376"></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="Expr1377"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1011"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1378]=(0) THEN NULL ELSE [Expr1379] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1378"></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="Expr1379"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1012"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1380]=(0) THEN NULL ELSE [Expr1381] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1380"></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="Expr1381"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1013"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1382]=(0) THEN NULL ELSE [Expr1383] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1382"></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="Expr1383"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1014"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1384]=(0) THEN NULL ELSE [Expr1385] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1384"></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="Expr1385"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1015"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1386]=(0) THEN NULL ELSE [Expr1387] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1386"></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="Expr1387"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1016"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1388]=(0) THEN NULL ELSE [Expr1389] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1388"></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="Expr1389"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1017"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1390]=(0) THEN NULL ELSE [Expr1391] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1390"></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="Expr1391"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1018"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1392]=(0) THEN NULL ELSE [Expr1393] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1392"></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="Expr1393"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1019"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1394]=(0) THEN NULL ELSE [Expr1395] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1394"></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="Expr1395"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1020"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1396]=(0) THEN NULL ELSE [Expr1397] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1396"></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="Expr1397"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1021"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1398]=(0) THEN NULL ELSE [Expr1399] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1398"></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="Expr1399"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1022"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1400]=(0) THEN NULL ELSE [Expr1401] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1400"></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="Expr1401"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1023"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1402]=(0) THEN NULL ELSE [Expr1403] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1402"></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="Expr1403"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1024"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1404]=(0) THEN NULL ELSE [Expr1405] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1404"></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="Expr1405"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1025"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1406]=(0) THEN NULL ELSE [Expr1407] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1406"></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="Expr1407"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1026"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1408]=(0) THEN NULL ELSE [Expr1409] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1408"></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="Expr1409"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1027"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1410]=(0) THEN NULL ELSE [Expr1411] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1410"></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="Expr1411"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1028"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1412]=(0) THEN NULL ELSE [Expr1413] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1412"></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="Expr1413"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1029"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1414]=(0) THEN NULL ELSE [Expr1415] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1414"></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="Expr1415"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1030"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1416]=(0) THEN NULL ELSE [Expr1417] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1416"></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="Expr1417"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1031"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1418]=(0) THEN NULL ELSE [Expr1419] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1418"></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="Expr1419"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1032"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1420]=(0) THEN NULL ELSE [Expr1421] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1420"></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="Expr1421"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1033"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1422]=(0) THEN NULL ELSE [Expr1423] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1422"></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="Expr1423"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="10" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="15" EstimateIO="0" EstimateCPU="0.370313" AvgRowSize="510" EstimatedTotalSubtreeCost="59.5755" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sq_ft"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_city"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_county"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_state"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Column="Expr1376"></ColumnReference><ColumnReference Column="Expr1377"></ColumnReference><ColumnReference Column="Expr1378"></ColumnReference><ColumnReference Column="Expr1379"></ColumnReference><ColumnReference Column="Expr1380"></ColumnReference><ColumnReference Column="Expr1381"></ColumnReference><ColumnReference Column="Expr1382"></ColumnReference><ColumnReference Column="Expr1383"></ColumnReference><ColumnReference Column="Expr1384"></ColumnReference><ColumnReference Column="Expr1385"></ColumnReference><ColumnReference Column="Expr1386"></ColumnReference><ColumnReference Column="Expr1387"></ColumnReference><ColumnReference Column="Expr1388"></ColumnReference><ColumnReference Column="Expr1389"></ColumnReference><ColumnReference Column="Expr1390"></ColumnReference><ColumnReference Column="Expr1391"></ColumnReference><ColumnReference Column="Expr1392"></ColumnReference><ColumnReference Column="Expr1393"></ColumnReference><ColumnReference Column="Expr1394"></ColumnReference><ColumnReference Column="Expr1395"></ColumnReference><ColumnReference Column="Expr1396"></ColumnReference><ColumnReference Column="Expr1397"></ColumnReference><ColumnReference Column="Expr1398"></ColumnReference><ColumnReference Column="Expr1399"></ColumnReference><ColumnReference Column="Expr1400"></ColumnReference><ColumnReference Column="Expr1401"></ColumnReference><ColumnReference Column="Expr1402"></ColumnReference><ColumnReference Column="Expr1403"></ColumnReference><ColumnReference Column="Expr1404"></ColumnReference><ColumnReference Column="Expr1405"></ColumnReference><ColumnReference Column="Expr1406"></ColumnReference><ColumnReference Column="Expr1407"></ColumnReference><ColumnReference Column="Expr1408"></ColumnReference><ColumnReference Column="Expr1409"></ColumnReference><ColumnReference Column="Expr1410"></ColumnReference><ColumnReference Column="Expr1411"></ColumnReference><ColumnReference Column="Expr1412"></ColumnReference><ColumnReference Column="Expr1413"></ColumnReference><ColumnReference Column="Expr1414"></ColumnReference><ColumnReference Column="Expr1415"></ColumnReference><ColumnReference Column="Expr1416"></ColumnReference><ColumnReference Column="Expr1417"></ColumnReference><ColumnReference Column="Expr1418"></ColumnReference><ColumnReference Column="Expr1419"></ColumnReference><ColumnReference Column="Expr1420"></ColumnReference><ColumnReference Column="Expr1421"></ColumnReference><ColumnReference Column="Expr1422"></ColumnReference><ColumnReference Column="Expr1423"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1376"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1275])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1275"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1377"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1275])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1275"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1378"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1276])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1276"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1379"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1276])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1276"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1380"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1277])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1277"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1381"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1277])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1277"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1382"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1278])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1278"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1383"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1278])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1278"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1384"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1279])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1279"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1385"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1279])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1279"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1386"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1280])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1280"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1387"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1280])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1280"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1388"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1281])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1281"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1389"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1281])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1281"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1390"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1282])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1282"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1391"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1282])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1282"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1392"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1283])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1283"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1393"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1283])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1283"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1394"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1284])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1284"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1395"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1284])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1284"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1396"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1285])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1285"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1397"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1285])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1285"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1398"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1286])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1286"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1399"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1286])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1286"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1400"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1287])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1287"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1401"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1287])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1287"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1402"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1288])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1288"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1403"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1288])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1288"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1404"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1289])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1289"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1405"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1289])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1289"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1406"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1290])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1290"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1407"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1290])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1290"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1408"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1291])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1291"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1409"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1291])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1291"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1410"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1292])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1292"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1411"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1292])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1292"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1412"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1293])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1293"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1413"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1293])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1293"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1414"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1294])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1294"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1415"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1294])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1294"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1416"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1295])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1295"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1417"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1295])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1295"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1418"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1296])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1296"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1419"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1296])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1296"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1420"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1297])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1297"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1421"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1297])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1297"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1422"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1298])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1298"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1423"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1298])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1298"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ScalarOperator ScalarString="ANY([TPCDS_SF100].[dbo].[date_dim].[d_year])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sq_ft"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_city"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_county"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_state"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_country"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[warehouse].[w_warehouse_name] = [TPCDS_SF100].[dbo].[warehouse].[w_warehouse_name] AND [TPCDS_SF100].[dbo].[warehouse].[w_warehouse_sq_ft] = [TPCDS_SF100].[dbo].[warehouse].[w_warehouse_sq_ft] AND [TPCDS_SF100].[dbo].[warehouse].[w_city] = [TPCDS_SF100].[dbo].[warehouse].[w_city] AND [TPCDS_SF100].[dbo].[warehouse].[w_county] = [TPCDS_SF100].[dbo].[warehouse].[w_county] AND [TPCDS_SF100].[dbo].[warehouse].[w_state] = [TPCDS_SF100].[dbo].[warehouse].[w_state] AND [TPCDS_SF100].[dbo].[warehouse].[w_country] = [TPCDS_SF100].[dbo].[warehouse].[w_country]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sq_ft"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sq_ft"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_city"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_city"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_county"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_county"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_state"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_country"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_country"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="11" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="551298" EstimateIO="0" EstimateCPU="0.00551298" AvgRowSize="318" EstimatedTotalSubtreeCost="59.2052" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sq_ft"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_city"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_county"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_state"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Column="Expr1275"></ColumnReference><ColumnReference Column="Expr1276"></ColumnReference><ColumnReference Column="Expr1277"></ColumnReference><ColumnReference Column="Expr1278"></ColumnReference><ColumnReference Column="Expr1279"></ColumnReference><ColumnReference Column="Expr1280"></ColumnReference><ColumnReference Column="Expr1281"></ColumnReference><ColumnReference Column="Expr1282"></ColumnReference><ColumnReference Column="Expr1283"></ColumnReference><ColumnReference Column="Expr1284"></ColumnReference><ColumnReference Column="Expr1285"></ColumnReference><ColumnReference Column="Expr1286"></ColumnReference><ColumnReference Column="Expr1287"></ColumnReference><ColumnReference Column="Expr1288"></ColumnReference><ColumnReference Column="Expr1289"></ColumnReference><ColumnReference Column="Expr1290"></ColumnReference><ColumnReference Column="Expr1291"></ColumnReference><ColumnReference Column="Expr1292"></ColumnReference><ColumnReference Column="Expr1293"></ColumnReference><ColumnReference Column="Expr1294"></ColumnReference><ColumnReference Column="Expr1295"></ColumnReference><ColumnReference Column="Expr1296"></ColumnReference><ColumnReference Column="Expr1297"></ColumnReference><ColumnReference Column="Expr1298"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1275"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(1) THEN [TPCDS_SF100].[dbo].[web_sales].[ws_ext_sales_price]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[web_sales].[ws_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1276"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(2) THEN [TPCDS_SF100].[dbo].[web_sales].[ws_ext_sales_price]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[web_sales].[ws_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1277"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(3) THEN [TPCDS_SF100].[dbo].[web_sales].[ws_ext_sales_price]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[web_sales].[ws_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1278"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(4) THEN [TPCDS_SF100].[dbo].[web_sales].[ws_ext_sales_price]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[web_sales].[ws_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(4)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1279"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(5) THEN [TPCDS_SF100].[dbo].[web_sales].[ws_ext_sales_price]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[web_sales].[ws_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(5)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1280"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(6) THEN [TPCDS_SF100].[dbo].[web_sales].[ws_ext_sales_price]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[web_sales].[ws_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(6)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1281"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(7) THEN [TPCDS_SF100].[dbo].[web_sales].[ws_ext_sales_price]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[web_sales].[ws_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(7)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1282"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(8) THEN [TPCDS_SF100].[dbo].[web_sales].[ws_ext_sales_price]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[web_sales].[ws_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(8)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1283"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(9) THEN [TPCDS_SF100].[dbo].[web_sales].[ws_ext_sales_price]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[web_sales].[ws_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(9)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1284"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(10) THEN [TPCDS_SF100].[dbo].[web_sales].[ws_ext_sales_price]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[web_sales].[ws_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(10)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1285"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(11) THEN [TPCDS_SF100].[dbo].[web_sales].[ws_ext_sales_price]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[web_sales].[ws_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(11)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1286"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(12) THEN [TPCDS_SF100].[dbo].[web_sales].[ws_ext_sales_price]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[web_sales].[ws_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(12)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1287"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(1) THEN [TPCDS_SF100].[dbo].[web_sales].[ws_net_paid]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[web_sales].[ws_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_paid"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1288"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(2) THEN [TPCDS_SF100].[dbo].[web_sales].[ws_net_paid]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[web_sales].[ws_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_paid"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1289"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(3) THEN [TPCDS_SF100].[dbo].[web_sales].[ws_net_paid]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[web_sales].[ws_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_paid"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1290"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(4) THEN [TPCDS_SF100].[dbo].[web_sales].[ws_net_paid]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[web_sales].[ws_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(4)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_paid"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1291"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(5) THEN [TPCDS_SF100].[dbo].[web_sales].[ws_net_paid]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[web_sales].[ws_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(5)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_paid"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1292"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(6) THEN [TPCDS_SF100].[dbo].[web_sales].[ws_net_paid]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[web_sales].[ws_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(6)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_paid"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1293"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(7) THEN [TPCDS_SF100].[dbo].[web_sales].[ws_net_paid]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[web_sales].[ws_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(7)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_paid"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1294"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(8) THEN [TPCDS_SF100].[dbo].[web_sales].[ws_net_paid]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[web_sales].[ws_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(8)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_paid"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1295"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(9) THEN [TPCDS_SF100].[dbo].[web_sales].[ws_net_paid]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[web_sales].[ws_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(9)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_paid"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1296"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(10) THEN [TPCDS_SF100].[dbo].[web_sales].[ws_net_paid]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[web_sales].[ws_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(10)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_paid"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1297"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(11) THEN [TPCDS_SF100].[dbo].[web_sales].[ws_net_paid]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[web_sales].[ws_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(11)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_paid"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1298"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(12) THEN [TPCDS_SF100].[dbo].[web_sales].[ws_net_paid]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[web_sales].[ws_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(12)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_paid"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="12" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="551298" EstimateIO="0" EstimateCPU="0.296303" AvgRowSize="118" EstimatedTotalSubtreeCost="59.1997" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_paid"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sq_ft"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_city"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_county"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_state"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_warehouse_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="13" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="15" EstimatedRowsRead="15" EstimateIO="0.003125" EstimateCPU="1.735e-05" AvgRowSize="99" EstimatedTotalSubtreeCost="0.00314235" TableCardinality="15" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sq_ft"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_city"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_county"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_state"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_country"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sq_ft"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_city"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_county"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_state"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_country"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="14" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="551298" EstimateIO="0" EstimateCPU="0.359364" AvgRowSize="33" EstimatedTotalSubtreeCost="58.9002" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_warehouse_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_paid"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1258"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="15" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="369.306" EstimatedRowsRead="73239" EstimateIO="0.0275496" EstimateCPU="0.00807199" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0356216" TableCardinality="73239" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_year]=(2001)"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2001)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="16" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.75288e+06" EstimateIO="0" EstimateCPU="0.44807" AvgRowSize="29" EstimatedTotalSubtreeCost="58.487" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_warehouse_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_paid"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1261"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[ship_mode]" Column="sm_ship_mode_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ship_mode_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="18" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2" EstimatedRowsRead="20" EstimateIO="0.003125" EstimateCPU="1.79e-05" AvgRowSize="21" EstimatedTotalSubtreeCost="0.0031429" TableCardinality="20" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[ship_mode]" Column="sm_ship_mode_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[ship_mode]" Column="sm_carrier"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[ship_mode]" Column="sm_ship_mode_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[ship_mode]" Column="sm_carrier"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[ship_mode]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[ship_mode].[sm_carrier]=&apos;BARIAN&apos; OR [TPCDS_SF100].[dbo].[ship_mode].[sm_carrier]=&apos;ORIENTAL&apos;"><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[ship_mode]" Column="sm_carrier"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;BARIAN&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[ship_mode]" Column="sm_carrier"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;ORIENTAL&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="19" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.75288e+07" EstimateIO="0" EstimateCPU="0.609448" AvgRowSize="33" EstimatedTotalSubtreeCost="58.0358" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ship_mode_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_warehouse_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_paid"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1262"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_time_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[web_sales].[ws_sold_time_sk]=[TPCDS_SF100].[dbo].[time_dim].[t_time_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_time_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="20" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="28579.4" EstimatedRowsRead="86254" EstimateIO="0.0257822" EstimateCPU="0.00950364" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0352858" TableCardinality="86254" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time_sk"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Index="[ClusteredIndex]" TableReferenceId="1" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[time_dim].[t_time]&gt;=(51258) AND [TPCDS_SF100].[dbo].[time_dim].[t_time]&lt;=(80058)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(51258)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(80058)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="21" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="7.18913e+07" EstimatedRowsRead="7.19256e+07" EstimateIO="48.1297" EstimateCPU="7.91183" AvgRowSize="37" EstimatedTotalSubtreeCost="56.0415" TableCardinality="7.19256e+07" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_time_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ship_mode_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_warehouse_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_paid"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_time_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ship_mode_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_warehouse_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ext_sales_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_net_paid"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[web_sales].[ws_sold_date_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[web_sales].[ws_sold_time_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[web_sales].[ws_ship_mode_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[web_sales].[ws_warehouse_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_sold_time_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_ship_mode_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[web_sales]" Column="ws_warehouse_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></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp><RelOp NodeId="22" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="15" EstimateIO="0" EstimateCPU="1.5e-07" AvgRowSize="513" EstimatedTotalSubtreeCost="119.158" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sq_ft"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_city"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_county"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_state"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Column="Expr1045"></ColumnReference><ColumnReference Column="Expr1046"></ColumnReference><ColumnReference Column="Expr1047"></ColumnReference><ColumnReference Column="Expr1048"></ColumnReference><ColumnReference Column="Expr1049"></ColumnReference><ColumnReference Column="Expr1050"></ColumnReference><ColumnReference Column="Expr1051"></ColumnReference><ColumnReference Column="Expr1052"></ColumnReference><ColumnReference Column="Expr1053"></ColumnReference><ColumnReference Column="Expr1054"></ColumnReference><ColumnReference Column="Expr1055"></ColumnReference><ColumnReference Column="Expr1056"></ColumnReference><ColumnReference Column="Expr1057"></ColumnReference><ColumnReference Column="Expr1058"></ColumnReference><ColumnReference Column="Expr1059"></ColumnReference><ColumnReference Column="Expr1060"></ColumnReference><ColumnReference Column="Expr1061"></ColumnReference><ColumnReference Column="Expr1062"></ColumnReference><ColumnReference Column="Expr1063"></ColumnReference><ColumnReference Column="Expr1064"></ColumnReference><ColumnReference Column="Expr1065"></ColumnReference><ColumnReference Column="Expr1066"></ColumnReference><ColumnReference Column="Expr1067"></ColumnReference><ColumnReference Column="Expr1068"></ColumnReference><ColumnReference Column="Expr1069"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1069"></ColumnReference><ScalarOperator ScalarString="&apos;BARIAN,ORIENTAL&apos;"><Const ConstValue="&apos;BARIAN,ORIENTAL&apos;"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="23" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="15" EstimateIO="0" EstimateCPU="0" AvgRowSize="504" EstimatedTotalSubtreeCost="119.158" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sq_ft"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_city"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_county"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_state"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Column="Expr1045"></ColumnReference><ColumnReference Column="Expr1046"></ColumnReference><ColumnReference Column="Expr1047"></ColumnReference><ColumnReference Column="Expr1048"></ColumnReference><ColumnReference Column="Expr1049"></ColumnReference><ColumnReference Column="Expr1050"></ColumnReference><ColumnReference Column="Expr1051"></ColumnReference><ColumnReference Column="Expr1052"></ColumnReference><ColumnReference Column="Expr1053"></ColumnReference><ColumnReference Column="Expr1054"></ColumnReference><ColumnReference Column="Expr1055"></ColumnReference><ColumnReference Column="Expr1056"></ColumnReference><ColumnReference Column="Expr1057"></ColumnReference><ColumnReference Column="Expr1058"></ColumnReference><ColumnReference Column="Expr1059"></ColumnReference><ColumnReference Column="Expr1060"></ColumnReference><ColumnReference Column="Expr1061"></ColumnReference><ColumnReference Column="Expr1062"></ColumnReference><ColumnReference Column="Expr1063"></ColumnReference><ColumnReference Column="Expr1064"></ColumnReference><ColumnReference Column="Expr1065"></ColumnReference><ColumnReference Column="Expr1066"></ColumnReference><ColumnReference Column="Expr1067"></ColumnReference><ColumnReference Column="Expr1068"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1045"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1424]=(0) THEN NULL ELSE [Expr1425] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1424"></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="Expr1425"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1046"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1426]=(0) THEN NULL ELSE [Expr1427] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1426"></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="Expr1427"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1047"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1428]=(0) THEN NULL ELSE [Expr1429] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1428"></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="Expr1429"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1048"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1430]=(0) THEN NULL ELSE [Expr1431] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1430"></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="Expr1431"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1049"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1432]=(0) THEN NULL ELSE [Expr1433] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1432"></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="Expr1433"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1050"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1434]=(0) THEN NULL ELSE [Expr1435] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1434"></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="Expr1435"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1051"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1436]=(0) THEN NULL ELSE [Expr1437] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1436"></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="Expr1437"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1052"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1438]=(0) THEN NULL ELSE [Expr1439] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1438"></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="Expr1439"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1053"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1440]=(0) THEN NULL ELSE [Expr1441] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1440"></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="Expr1441"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1054"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1442]=(0) THEN NULL ELSE [Expr1443] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1442"></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="Expr1443"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1055"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1444]=(0) THEN NULL ELSE [Expr1445] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1444"></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="Expr1445"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1056"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1446]=(0) THEN NULL ELSE [Expr1447] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1446"></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="Expr1447"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1057"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1448]=(0) THEN NULL ELSE [Expr1449] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1448"></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="Expr1449"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1058"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1450]=(0) THEN NULL ELSE [Expr1451] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1450"></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="Expr1451"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1059"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1452]=(0) THEN NULL ELSE [Expr1453] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1452"></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="Expr1453"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1060"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1454]=(0) THEN NULL ELSE [Expr1455] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1454"></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="Expr1455"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1061"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1456]=(0) THEN NULL ELSE [Expr1457] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1456"></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="Expr1457"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1062"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1458]=(0) THEN NULL ELSE [Expr1459] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1458"></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="Expr1459"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1063"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1460]=(0) THEN NULL ELSE [Expr1461] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1460"></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="Expr1461"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1064"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1462]=(0) THEN NULL ELSE [Expr1463] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1462"></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="Expr1463"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1065"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1464]=(0) THEN NULL ELSE [Expr1465] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1464"></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="Expr1465"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1066"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1466]=(0) THEN NULL ELSE [Expr1467] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1466"></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="Expr1467"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1067"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1468]=(0) THEN NULL ELSE [Expr1469] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1468"></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="Expr1469"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1068"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1470]=(0) THEN NULL ELSE [Expr1471] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1470"></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="Expr1471"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="24" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="15" EstimateIO="0" EstimateCPU="0.746482" AvgRowSize="504" EstimatedTotalSubtreeCost="119.158" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sq_ft"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_city"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_county"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_state"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Column="Expr1424"></ColumnReference><ColumnReference Column="Expr1425"></ColumnReference><ColumnReference Column="Expr1426"></ColumnReference><ColumnReference Column="Expr1427"></ColumnReference><ColumnReference Column="Expr1428"></ColumnReference><ColumnReference Column="Expr1429"></ColumnReference><ColumnReference Column="Expr1430"></ColumnReference><ColumnReference Column="Expr1431"></ColumnReference><ColumnReference Column="Expr1432"></ColumnReference><ColumnReference Column="Expr1433"></ColumnReference><ColumnReference Column="Expr1434"></ColumnReference><ColumnReference Column="Expr1435"></ColumnReference><ColumnReference Column="Expr1436"></ColumnReference><ColumnReference Column="Expr1437"></ColumnReference><ColumnReference Column="Expr1438"></ColumnReference><ColumnReference Column="Expr1439"></ColumnReference><ColumnReference Column="Expr1440"></ColumnReference><ColumnReference Column="Expr1441"></ColumnReference><ColumnReference Column="Expr1442"></ColumnReference><ColumnReference Column="Expr1443"></ColumnReference><ColumnReference Column="Expr1444"></ColumnReference><ColumnReference Column="Expr1445"></ColumnReference><ColumnReference Column="Expr1446"></ColumnReference><ColumnReference Column="Expr1447"></ColumnReference><ColumnReference Column="Expr1448"></ColumnReference><ColumnReference Column="Expr1449"></ColumnReference><ColumnReference Column="Expr1450"></ColumnReference><ColumnReference Column="Expr1451"></ColumnReference><ColumnReference Column="Expr1452"></ColumnReference><ColumnReference Column="Expr1453"></ColumnReference><ColumnReference Column="Expr1454"></ColumnReference><ColumnReference Column="Expr1455"></ColumnReference><ColumnReference Column="Expr1456"></ColumnReference><ColumnReference Column="Expr1457"></ColumnReference><ColumnReference Column="Expr1458"></ColumnReference><ColumnReference Column="Expr1459"></ColumnReference><ColumnReference Column="Expr1460"></ColumnReference><ColumnReference Column="Expr1461"></ColumnReference><ColumnReference Column="Expr1462"></ColumnReference><ColumnReference Column="Expr1463"></ColumnReference><ColumnReference Column="Expr1464"></ColumnReference><ColumnReference Column="Expr1465"></ColumnReference><ColumnReference Column="Expr1466"></ColumnReference><ColumnReference Column="Expr1467"></ColumnReference><ColumnReference Column="Expr1468"></ColumnReference><ColumnReference Column="Expr1469"></ColumnReference><ColumnReference Column="Expr1470"></ColumnReference><ColumnReference Column="Expr1471"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1424"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1340])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1340"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1425"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1340])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1340"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1426"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1341])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1341"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1427"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1341])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1341"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1428"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1342])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1342"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1429"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1342])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1342"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1430"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1343])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1343"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1431"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1343])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1343"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1432"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1344])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1344"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1433"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1344])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1344"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1434"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1345])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1345"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1435"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1345])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1345"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1436"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1346])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1346"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1437"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1346])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1346"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1438"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1347])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1347"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1439"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1347])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1347"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1440"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1348])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1348"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1441"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1348])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1348"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1442"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1349])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1349"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1443"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1349])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1349"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1444"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1350])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1350"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1445"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1350])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1350"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1446"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1351])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1351"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1447"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1351])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1351"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1448"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1352])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1352"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1449"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1352])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1352"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1450"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1353])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1353"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1451"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1353])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1353"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1452"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1354])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1354"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1453"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1354])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1354"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1454"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1355])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1355"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1455"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1355])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1355"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1456"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1356])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1356"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1457"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1356])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1356"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1458"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1357])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1357"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1459"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1357])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1357"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1460"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1358])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1358"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1461"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1358])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1358"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1462"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1359])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1359"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1463"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1359])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1359"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1464"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1360])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1360"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1465"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1360])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1360"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1466"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1361])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1361"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1467"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1361])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1361"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1468"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1362])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1362"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1469"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1362])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1362"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1470"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG([Expr1363])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1363"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1471"></ColumnReference><ScalarOperator ScalarString="SUM([Expr1363])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1363"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ScalarOperator ScalarString="ANY([TPCDS_SF100].[dbo].[date_dim].[d_year])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sq_ft"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_city"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_county"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_state"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_country"></ColumnReference></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[warehouse].[w_warehouse_name] = [TPCDS_SF100].[dbo].[warehouse].[w_warehouse_name] AND [TPCDS_SF100].[dbo].[warehouse].[w_warehouse_sq_ft] = [TPCDS_SF100].[dbo].[warehouse].[w_warehouse_sq_ft] AND [TPCDS_SF100].[dbo].[warehouse].[w_city] = [TPCDS_SF100].[dbo].[warehouse].[w_city] AND [TPCDS_SF100].[dbo].[warehouse].[w_county] = [TPCDS_SF100].[dbo].[warehouse].[w_county] AND [TPCDS_SF100].[dbo].[warehouse].[w_state] = [TPCDS_SF100].[dbo].[warehouse].[w_state] AND [TPCDS_SF100].[dbo].[warehouse].[w_country] = [TPCDS_SF100].[dbo].[warehouse].[w_country]"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sq_ft"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sq_ft"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_city"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_city"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_county"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_county"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_state"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_state"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_country"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_country"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></BuildResidual><RelOp NodeId="25" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.11455e+06" EstimateIO="0" EstimateCPU="0.0111455" AvgRowSize="312" EstimatedTotalSubtreeCost="118.411" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sq_ft"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_city"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_county"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_state"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Column="Expr1340"></ColumnReference><ColumnReference Column="Expr1341"></ColumnReference><ColumnReference Column="Expr1342"></ColumnReference><ColumnReference Column="Expr1343"></ColumnReference><ColumnReference Column="Expr1344"></ColumnReference><ColumnReference Column="Expr1345"></ColumnReference><ColumnReference Column="Expr1346"></ColumnReference><ColumnReference Column="Expr1347"></ColumnReference><ColumnReference Column="Expr1348"></ColumnReference><ColumnReference Column="Expr1349"></ColumnReference><ColumnReference Column="Expr1350"></ColumnReference><ColumnReference Column="Expr1351"></ColumnReference><ColumnReference Column="Expr1352"></ColumnReference><ColumnReference Column="Expr1353"></ColumnReference><ColumnReference Column="Expr1354"></ColumnReference><ColumnReference Column="Expr1355"></ColumnReference><ColumnReference Column="Expr1356"></ColumnReference><ColumnReference Column="Expr1357"></ColumnReference><ColumnReference Column="Expr1358"></ColumnReference><ColumnReference Column="Expr1359"></ColumnReference><ColumnReference Column="Expr1360"></ColumnReference><ColumnReference Column="Expr1361"></ColumnReference><ColumnReference Column="Expr1362"></ColumnReference><ColumnReference Column="Expr1363"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1340"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(1) THEN [TPCDS_SF100].[dbo].[catalog_sales].[cs_ext_sales_price]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[catalog_sales].[cs_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1341"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(2) THEN [TPCDS_SF100].[dbo].[catalog_sales].[cs_ext_sales_price]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[catalog_sales].[cs_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1342"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(3) THEN [TPCDS_SF100].[dbo].[catalog_sales].[cs_ext_sales_price]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[catalog_sales].[cs_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1343"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(4) THEN [TPCDS_SF100].[dbo].[catalog_sales].[cs_ext_sales_price]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[catalog_sales].[cs_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(4)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1344"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(5) THEN [TPCDS_SF100].[dbo].[catalog_sales].[cs_ext_sales_price]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[catalog_sales].[cs_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(5)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1345"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(6) THEN [TPCDS_SF100].[dbo].[catalog_sales].[cs_ext_sales_price]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[catalog_sales].[cs_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(6)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1346"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(7) THEN [TPCDS_SF100].[dbo].[catalog_sales].[cs_ext_sales_price]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[catalog_sales].[cs_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(7)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1347"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(8) THEN [TPCDS_SF100].[dbo].[catalog_sales].[cs_ext_sales_price]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[catalog_sales].[cs_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(8)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1348"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(9) THEN [TPCDS_SF100].[dbo].[catalog_sales].[cs_ext_sales_price]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[catalog_sales].[cs_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(9)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1349"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(10) THEN [TPCDS_SF100].[dbo].[catalog_sales].[cs_ext_sales_price]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[catalog_sales].[cs_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(10)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1350"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(11) THEN [TPCDS_SF100].[dbo].[catalog_sales].[cs_ext_sales_price]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[catalog_sales].[cs_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(11)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1351"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(12) THEN [TPCDS_SF100].[dbo].[catalog_sales].[cs_ext_sales_price]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[catalog_sales].[cs_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(12)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1352"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(1) THEN [TPCDS_SF100].[dbo].[catalog_sales].[cs_net_paid_inc_ship]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[catalog_sales].[cs_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_paid_inc_ship"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1353"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(2) THEN [TPCDS_SF100].[dbo].[catalog_sales].[cs_net_paid_inc_ship]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[catalog_sales].[cs_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_paid_inc_ship"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1354"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(3) THEN [TPCDS_SF100].[dbo].[catalog_sales].[cs_net_paid_inc_ship]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[catalog_sales].[cs_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_paid_inc_ship"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1355"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(4) THEN [TPCDS_SF100].[dbo].[catalog_sales].[cs_net_paid_inc_ship]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[catalog_sales].[cs_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(4)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_paid_inc_ship"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1356"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(5) THEN [TPCDS_SF100].[dbo].[catalog_sales].[cs_net_paid_inc_ship]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[catalog_sales].[cs_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(5)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_paid_inc_ship"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1357"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(6) THEN [TPCDS_SF100].[dbo].[catalog_sales].[cs_net_paid_inc_ship]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[catalog_sales].[cs_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(6)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_paid_inc_ship"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1358"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(7) THEN [TPCDS_SF100].[dbo].[catalog_sales].[cs_net_paid_inc_ship]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[catalog_sales].[cs_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(7)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_paid_inc_ship"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1359"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(8) THEN [TPCDS_SF100].[dbo].[catalog_sales].[cs_net_paid_inc_ship]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[catalog_sales].[cs_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(8)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_paid_inc_ship"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1360"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(9) THEN [TPCDS_SF100].[dbo].[catalog_sales].[cs_net_paid_inc_ship]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[catalog_sales].[cs_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(9)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_paid_inc_ship"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1361"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(10) THEN [TPCDS_SF100].[dbo].[catalog_sales].[cs_net_paid_inc_ship]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[catalog_sales].[cs_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(10)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_paid_inc_ship"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1362"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(11) THEN [TPCDS_SF100].[dbo].[catalog_sales].[cs_net_paid_inc_ship]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[catalog_sales].[cs_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(11)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_paid_inc_ship"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1363"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [TPCDS_SF100].[dbo].[date_dim].[d_moy]=(12) THEN [TPCDS_SF100].[dbo].[catalog_sales].[cs_net_paid_inc_ship]*CONVERT_IMPLICIT(decimal(10,0),[TPCDS_SF100].[dbo].[catalog_sales].[cs_quantity],0) ELSE (0.00) END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(12)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_paid_inc_ship"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="decimal" Precision="10" Scale="0" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0.00)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="26" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.11455e+06" EstimateIO="0" EstimateCPU="0.597131" AvgRowSize="112" EstimatedTotalSubtreeCost="118.4" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_paid_inc_ship"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sq_ft"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_city"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_county"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_state"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_country"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_warehouse_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="27" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="15" EstimatedRowsRead="15" EstimateIO="0.003125" EstimateCPU="1.735e-05" AvgRowSize="93" EstimatedTotalSubtreeCost="0.00314235" TableCardinality="15" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sq_ft"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_city"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_county"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_state"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_country"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_warehouse_sq_ft"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_city"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_county"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_state"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Column="w_country"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[warehouse]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object></IndexScan></RelOp><RelOp NodeId="28" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.11455e+06" EstimateIO="0" EstimateCPU="0.724536" AvgRowSize="33" EstimatedTotalSubtreeCost="117.8" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_warehouse_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_paid_inc_ship"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1332"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[ship_mode]" Column="sm_ship_mode_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ship_mode_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="30" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2" EstimatedRowsRead="20" EstimateIO="0.003125" EstimateCPU="1.79e-05" AvgRowSize="25" EstimatedTotalSubtreeCost="0.0031429" TableCardinality="20" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[ship_mode]" Column="sm_ship_mode_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[ship_mode]" Column="sm_carrier"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[ship_mode]" Column="sm_ship_mode_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[ship_mode]" Column="sm_carrier"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[ship_mode]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[ship_mode].[sm_carrier]=&apos;BARIAN&apos; OR [TPCDS_SF100].[dbo].[ship_mode].[sm_carrier]=&apos;ORIENTAL&apos;"><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[ship_mode]" Column="sm_carrier"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;BARIAN&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[ship_mode]" Column="sm_carrier"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;ORIENTAL&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="31" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.11455e+07" EstimateIO="0" EstimateCPU="0.910377" AvgRowSize="37" EstimatedTotalSubtreeCost="117.072" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ship_mode_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_warehouse_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_paid_inc_ship"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1334"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></HashKeysProbe><RelOp NodeId="32" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="369.306" EstimatedRowsRead="73239" EstimateIO="0.0275496" EstimateCPU="0.00807199" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0356216" TableCardinality="73239" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_moy"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[date_dim].[d_year]=(2001)"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[date_dim]" Column="d_year"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2001)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="33" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="5.60531e+07" EstimateIO="0" EstimateCPU="1.18388" AvgRowSize="33" EstimatedTotalSubtreeCost="116.108" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ship_mode_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_warehouse_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_paid_inc_ship"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><Hash BitmapCreator="1"><DefinedValues><DefinedValue><ColumnReference Column="Opt_Bitmap1331"></ColumnReference></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time_sk"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_time_sk"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[catalog_sales].[cs_sold_time_sk]=[TPCDS_SF100].[dbo].[time_dim].[t_time_sk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_time_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time_sk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="34" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="28579.4" EstimatedRowsRead="86254" EstimateIO="0.0257822" EstimateCPU="0.00950364" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0352858" TableCardinality="86254" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time_sk"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time_sk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Index="[ClusteredIndex]" TableReferenceId="2" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[time_dim].[t_time]&gt;=(51258) AND [TPCDS_SF100].[dbo].[time_dim].[t_time]&lt;=(80058)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(51258)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[time_dim]" Column="t_time"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(80058)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="35" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.42698e+08" EstimatedRowsRead="1.44063e+08" EstimateIO="96.3985" EstimateCPU="15.8469" AvgRowSize="37" EstimatedTotalSubtreeCost="112.245" TableCardinality="1.44063e+08" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_time_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ship_mode_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_warehouse_sk"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_paid_inc_ship"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="ColumnStore"><DefinedValues><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_time_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ship_mode_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_warehouse_sk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_quantity"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ext_sales_price"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_net_paid_inc_ship"></ColumnReference></DefinedValue></DefinedValues><Object Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Index="[ClusteredIndex]" IndexKind="Clustered" Storage="ColumnStore"></Object><Predicate><ScalarOperator ScalarString="[TPCDS_SF100].[dbo].[catalog_sales].[cs_sold_date_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[catalog_sales].[cs_sold_time_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[catalog_sales].[cs_ship_mode_sk] IS NOT NULL AND [TPCDS_SF100].[dbo].[catalog_sales].[cs_warehouse_sk] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_date_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_sold_time_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_ship_mode_sk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[TPCDS_SF100]" Schema="[dbo]" Table="[catalog_sales]" Column="cs_warehouse_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></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></Concat></RelOp></ComputeScalar></RelOp></Hash></RelOp></ComputeScalar></RelOp></TopSort></RelOp></Move></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
