SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE [dbo].[bet] (
	[bookmaker_id] [int] NOT NULL,
	[provider_id] [int] NOT NULL,
	[round_id] [nvarchar](60) NOT NULL,
	[transaction_id] [nvarchar](60) NOT NULL,
	[game_id] [nvarchar](60) NOT NULL,
	[user_id] [nvarchar](60) NOT NULL,
	[bet_amount] [decimal](19, 2) NOT NULL,
	[balance] [decimal](19, 2) NOT NULL,
	[bet_timestamp] [datetime] NOT NULL,
	PRIMARY KEY (bookmaker_id , provider_id , transaction_id)
	)
INSERT INTO bet 
([bookmaker_id],[provider_id],[round_id],[transaction_id],[game_id],[user_id],[bet_amount],[balance],[bet_timestamp])
VALUES
(1,1,'Round1','bet_tx1','game1','123',10.00,90.00,'2022-03-17 01:40:57.400'),
(1,1,'Round2','bet_tx2','game1','123',10.00,70.00,'2022-03-17 02:40:57.400'),
(1,1,'Round2','bet_tx3','game1','123',10.00,80.00,'2022-03-17 03:40:57.400'),
(1,1,'Round3','bet_tx4','game1','123',10.00,70.00,'2022-03-17 04:40:57.400')



CREATE TABLE [dbo].[win](
	[bookmaker_id] [int] NOT NULL,
	[provider_id] [int] NOT NULL,
	[round_id] [nvarchar](60) NOT NULL,
	[transaction_id] [nvarchar](60) NOT NULL,
	[user_id] [nvarchar](60) NOT NULL,
	[win_amount] [decimal](19, 2) NOT NULL,
	[balance] [decimal](19, 2) NOT NULL,
	[win_timestamp] [datetime] NOT NULL ,
	PRIMARY KEY (bookmaker_id , provider_id , transaction_id)
  ) 
INSERT INTO win 
([bookmaker_id],[provider_id],[round_id],[transaction_id],[user_id],[win_amount],[balance],[win_timestamp])
VALUES
(1,1,'Round1','win_tx1' ,'123',0.00,80.00,'2022-03-17 01:40:57.400'),
(1,1,'Round2','win_tx2' ,'123',10.00,80.00,'2022-03-17 02:40:57.400')

 
CREATE TABLE [dbo].[cancel](
	[bookmaker_id] [int] NOT NULL,
	[provider_id] [int] NOT NULL,
	[round_id] [nvarchar](60) NOT NULL,
	[transaction_id] [nvarchar](60) NOT NULL,
	[user_id] [nvarchar](60) NOT NULL,
	[cancel_timestamp] [datetime] NOT NULL ,
	PRIMARY KEY (bookmaker_id , provider_id , transaction_id)
 )  
 
 INSERT INTO cancel 
([bookmaker_id],[provider_id],[round_id],[transaction_id],[user_id],[cancel_timestamp])
VALUES
(1,1,'Round3','can_tx1' ,'123','2022-03-17 01:40:57.400')
7 rows affected

CREATE INDEX IX_bet ON bet(bookmaker_id, provider_id, round_id);
CREATE INDEX IX_cancel ON cancel(bookmaker_id, provider_id, round_id);
CREATE INDEX IX_WIN ON win(bookmaker_id, provider_id, round_id);

SET SHOWPLAN_XML ON
SELECT 
  bet.*, 
  win.*, 
  cancel.transaction_id as cancel_transaction_id, 
  cancel.cancel_timestamp 
FROM 
  (
    SELECT 
      round_id, 
      game_id, 
      provider_id, 
      bookmaker_id, 
      user_id, 
      STRING_AGG(bet.transaction_id, ', ') as bet_transaction_ids, 
      SUM(bet_amount) as total_bet, 
      MIN(bet_timestamp) as bet_timestamp, 
      opening_balance 
    FROM 
      (
        SELECT 
          FIRST_VALUE(balance) OVER (
            PARTITION BY round_id 
            order by 
              bet_timestamp asc
          ) as opening_balance, 
          * 
        FROM 
          bet 
        WHERE 
          bookmaker_id = 1 
          AND provider_id = 1 
          AND transaction_id = 'bet_tx1'
      ) AS bet 
    GROUP BY 
      round_id, 
      game_id, 
      provider_id, 
      bookmaker_id, 
      user_id, 
      opening_balance
  ) AS bet 
  LEFT JOIN (
    SELECT 
      round_id, 
      STRING_AGG(win.transaction_id, ', ') as win_transaction_ids, 
      SUM(win_amount) as total_won, 
      MAX(win_timestamp) as win_timestamp, 
      closing_balance 
    FROM 
      (
        SELECT 
          FIRST_VALUE(balance) OVER (
            PARTITION BY round_id 
            ORDER BY 
              win_timestamp desc
          ) AS closing_balance, 
          * 
        FROM 
          win
      ) AS win 
    GROUP BY 
      win.round_id, 
      closing_balance
  ) AS win ON bet.round_id = win.round_id 
  LEFT JOIN (
    SELECT 
      [round_id], 
      [transaction_id], 
      [cancel_timestamp] 
    FROM 
      cancel
  ) AS cancel ON bet.round_id = cancel.round_id 
ORDER BY 
  total_won;
  


Microsoft SQL Server 2005 XML Showplan


<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.539" Build="15.0.4053.23"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT &#xa;  bet.*, &#xa;  win.*, &#xa;  cancel.transaction_id as cancel_transaction_id, &#xa;  cancel.cancel_timestamp &#xa;FROM &#xa;  (&#xa;    SELECT &#xa;      round_id, &#xa;      game_id, &#xa;      provider_id, &#xa;      bookmaker_id, &#xa;      user_id, &#xa;      STRING_AGG(bet.transaction_id, &apos;, &apos;) as bet_transaction_ids, &#xa;      SUM(bet_amount) as total_bet, &#xa;      MIN(bet_timestamp) as bet_timestamp, &#xa;      opening_balance &#xa;    FROM &#xa;      (&#xa;        SELECT &#xa;          FIRST_VALUE(balance) OVER (&#xa;            PARTITION BY round_id &#xa;            order by &#xa;              bet_timestamp asc&#xa;          ) as opening_balance, &#xa;          * &#xa;        FROM &#xa;          bet &#xa;        WHERE &#xa;          bookmaker_id = 1 &#xa;          AND provider_id = 1 &#xa;          AND transaction_id = &apos;bet_tx1&apos;&#xa;      ) AS bet &#xa;    GROUP BY &#xa;      round_id, &#xa;      game_id, &#xa;      provider_id, &#xa;      bookmaker_id, &#xa;      user_id, &#xa;      opening_balance&#xa;  ) AS bet &#xa;  LEFT JOIN (&#xa;    SELECT &#xa;      round_id, &#xa;      STRING_AGG(win.transaction_id, &apos;, &apos;) as win_transaction_ids, &#xa;      SUM(win_amount) as total_won, &#xa;      MAX(win_timestamp) as win_timestamp, &#xa;      closing_balance &#xa;    FROM &#xa;      (&#xa;        SELECT &#xa;          FIRST_VALUE(balance) OVER (&#xa;            PARTITION BY round_id &#xa;            ORDER BY &#xa;              win_timestamp desc&#xa;          ) AS closing_balance, &#xa;          * &#xa;        FROM &#xa;          win&#xa;      ) AS win &#xa;    GROUP BY &#xa;      win.round_id, &#xa;      closing_balance&#xa;  ) AS win ON bet.round_id = win.round_id &#xa;  LEFT JOIN (&#xa;    SELECT &#xa;      [round_id], &#xa;      [transaction_id], &#xa;      [cancel_timestamp] &#xa;    FROM &#xa;      cancel&#xa;  ) AS cancel ON bet.round_id = cancel.round_id &#xa;ORDER BY &#xa;  total_won" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="0.0439623" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xD5870A4B75332125" QueryPlanHash="0xF4F2DE49ECFEBE3D" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="150"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="128" CompileTime="31" CompileCPU="15" CompileMemory="800"><MemoryGrantInfo SerialRequiredMemory="640" SerialDesiredMemory="704" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="838808" EstimatedPagesCached="52425" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="3914648"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2022-06-12T18:13:27.94" ModificationCount="0" SamplingPercent="100" Statistics="[PK__win__63D79B34F1F9CF8B]" Table="[win]" Schema="[dbo]" Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-06-12T18:13:27.94" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000003_267ABA7A]" Table="[cancel]" Schema="[dbo]" Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-06-12T18:13:27.92" ModificationCount="0" SamplingPercent="100" Statistics="[IX_cancel]" Table="[cancel]" Schema="[dbo]" Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-06-12T18:13:27.94" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000003_24927208]" Table="[win]" Schema="[dbo]" Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-06-12T18:13:27.94" ModificationCount="0" SamplingPercent="100" Statistics="[PK__bet__63D79B344663B27C]" Table="[bet]" Schema="[dbo]" Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-06-12T18:13:27.91" ModificationCount="0" SamplingPercent="100" Statistics="[IX_bet]" Table="[bet]" Schema="[dbo]" Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-06-12T18:13:27.95" ModificationCount="0" SamplingPercent="100" Statistics="[PK__cancel__63D79B34F4CAF32C]" Table="[cancel]" Schema="[dbo]" Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-06-12T18:13:27.92" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000003_22AA2996]" Table="[bet]" Schema="[dbo]" Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-06-12T18:13:27.94" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000002_22AA2996]" Table="[bet]" Schema="[dbo]" Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-06-12T18:13:27.92" ModificationCount="0" SamplingPercent="100" Statistics="[IX_WIN]" Table="[win]" Schema="[dbo]" Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><RelOp NodeId="0" PhysicalOp="Nested Loops" LogicalOp="Left Outer Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-06" AvgRowSize="8330" EstimatedTotalSubtreeCost="0.0439623" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bookmaker_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="provider_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="game_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="user_id"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference></OutputList><NestedLoops Optimized="0"><Predicate><ScalarOperator ScalarString="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[bet].[round_id]=[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[cancel].[round_id]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="round_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[cancel]" Column="round_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Predicate><RelOp NodeId="1" PhysicalOp="Nested Loops" LogicalOp="Left Outer Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-06" AvgRowSize="8259" EstimatedTotalSubtreeCost="0.0406746" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bookmaker_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="provider_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="game_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="user_id"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference></OutputList><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="round_id"></ColumnReference></OuterReferences><RelOp NodeId="2" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="4192" EstimatedTotalSubtreeCost="0.00328644" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bookmaker_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="provider_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="game_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="user_id"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1003"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(4000),[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[bet].[transaction_id],0)"><Convert DataType="nvarchar" Length="8000" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="transaction_id"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1004"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(decimal(38,2),[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[bet].[bet_amount],0)"><Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bet_amount"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1005"></ColumnReference><ScalarOperator ScalarString="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[bet].[bet_timestamp]"><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bet_timestamp"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="3" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="244" EstimatedTotalSubtreeCost="0.00328634" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bookmaker_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="provider_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="transaction_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="game_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="user_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bet_amount"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bet_timestamp"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1002"></ColumnReference><ScalarOperator ScalarString="CASE WHEN IsFalseOrNull [Expr1022] THEN [Expr1023] ELSE NULL END"><IF><Condition><ScalarOperator><Logical Operation="IsFalseOrNull"><ScalarOperator><Identifier><ColumnReference Column="Expr1022"></ColumnReference></Identifier></ScalarOperator></Logical></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1023"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="4" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="6.28e-07" AvgRowSize="260" EstimatedTotalSubtreeCost="0.00328624" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bookmaker_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="provider_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="transaction_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="game_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="user_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bet_amount"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bet_timestamp"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference></OutputList><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1022"></ColumnReference><ScalarOperator ScalarString="FIRST_VALUE_IS_NULL([fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[bet].[balance])"><Aggregate Distinct="0" AggType="FIRST_VALUE_IS_NULL"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="balance"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1023"></ColumnReference><ScalarOperator ScalarString="FIRST_VALUE_IGNORE_NULLS([fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[bet].[balance])"><Aggregate Distinct="0" AggType="FIRST_VALUE_IGNORE_NULLS"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="balance"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bookmaker_id"></ColumnReference><ScalarOperator ScalarString="ANY([fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[bet].[bookmaker_id])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bookmaker_id"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="provider_id"></ColumnReference><ScalarOperator ScalarString="ANY([fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[bet].[provider_id])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="provider_id"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="round_id"></ColumnReference><ScalarOperator ScalarString="ANY([fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[bet].[round_id])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="round_id"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="transaction_id"></ColumnReference><ScalarOperator ScalarString="ANY([fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[bet].[transaction_id])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="transaction_id"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="game_id"></ColumnReference><ScalarOperator ScalarString="ANY([fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[bet].[game_id])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="game_id"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="user_id"></ColumnReference><ScalarOperator ScalarString="ANY([fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[bet].[user_id])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="user_id"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bet_amount"></ColumnReference><ScalarOperator ScalarString="ANY([fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[bet].[bet_amount])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bet_amount"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bet_timestamp"></ColumnReference><ScalarOperator ScalarString="ANY([fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[bet].[bet_timestamp])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bet_timestamp"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Column="WindowCount1030"></ColumnReference></GroupBy><RelOp NodeId="5" PhysicalOp="Window Spool" LogicalOp="Window Spool" EstimateRows="2" EstimateIO="0" EstimateCPU="2.198e-06" AvgRowSize="260" EstimatedTotalSubtreeCost="0.00328561" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bookmaker_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="provider_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="transaction_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="game_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="user_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bet_amount"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="balance"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bet_timestamp"></ColumnReference><ColumnReference Column="WindowCount1030"></ColumnReference><ColumnReference Column="Segment1028"></ColumnReference><ColumnReference Column="Segment1029"></ColumnReference></OutputList><WindowSpool><RelOp NodeId="6" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="260" EstimatedTotalSubtreeCost="0.00328316" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bookmaker_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="provider_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="transaction_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="game_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="user_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bet_amount"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="balance"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bet_timestamp"></ColumnReference><ColumnReference Column="Segment1028"></ColumnReference><ColumnReference Column="Segment1029"></ColumnReference></OutputList><Segment><GroupBy></GroupBy><SegmentColumn><ColumnReference Column="Segment1029"></ColumnReference></SegmentColumn><RelOp NodeId="7" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="1" EstimateIO="0" EstimateCPU="6.28e-08" AvgRowSize="252" EstimatedTotalSubtreeCost="0.00328316" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bookmaker_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="provider_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="transaction_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="game_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="user_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bet_amount"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="balance"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bet_timestamp"></ColumnReference><ColumnReference Column="Segment1028"></ColumnReference></OutputList><Segment><GroupBy></GroupBy><SegmentColumn><ColumnReference Column="Segment1028"></ColumnReference></SegmentColumn><RelOp NodeId="8" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="244" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="4" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bookmaker_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="provider_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="transaction_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="game_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="user_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bet_amount"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="balance"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bet_timestamp"></ColumnReference></OutputList><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bookmaker_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="provider_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="round_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="transaction_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="game_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="user_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bet_amount"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="balance"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bet_timestamp"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Index="[PK__bet__63D79B344663B27C]" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bookmaker_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="provider_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="transaction_id"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator><ScalarOperator ScalarString="N&apos;bet_tx1&apos;"><Const ConstValue="N&apos;bet_tx1&apos;"></Const></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></Segment></RelOp></Segment></RelOp></WindowSpool></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp><RelOp NodeId="9" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="4076" EstimatedTotalSubtreeCost="0.037384" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1012"></ColumnReference><ScalarOperator ScalarString="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[win].[round_id]"><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1013"></ColumnReference><ScalarOperator ScalarString="[Expr1009]"><Identifier><ColumnReference Column="Expr1009"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1014"></ColumnReference><ScalarOperator ScalarString="[Expr1010]"><Identifier><ColumnReference Column="Expr1010"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1015"></ColumnReference><ScalarOperator ScalarString="[Expr1011]"><Identifier><ColumnReference Column="Expr1011"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1016"></ColumnReference><ScalarOperator ScalarString="[Expr1008]"><Identifier><ColumnReference Column="Expr1008"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="10" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="1" EstimateIO="0.0112613" EstimateCPU="0.000104059" AvgRowSize="4059" EstimatedTotalSubtreeCost="0.0373839" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference></OutputList><MemoryFractions Input="0.5" Output="1"></MemoryFractions><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Column="Expr1010"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="11" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="1.1e-06" AvgRowSize="4059" EstimatedTotalSubtreeCost="0.0260186" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference></OutputList><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1009"></ColumnReference><ScalarOperator ScalarString="STRING_AGG([fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[win].[transaction_id],N&apos;, &apos;)"><Aggregate Distinct="0" AggType="STRING_AGG"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="transaction_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="N&apos;, &apos;"></Const></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1010"></ColumnReference><ScalarOperator ScalarString="SUM([fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[win].[win_amount])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_amount"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1011"></ColumnReference><ScalarOperator ScalarString="MAX([fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[win].[win_timestamp])"><Aggregate Distinct="0" AggType="MAX"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_timestamp"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference><ScalarOperator ScalarString="ANY([fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[win].[round_id])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Column="Expr1008"></ColumnReference></GroupBy><RelOp NodeId="12" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="1" EstimateIO="0.0112613" EstimateCPU="0.000100111" AvgRowSize="111" EstimatedTotalSubtreeCost="0.0260175" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="transaction_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_amount"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_timestamp"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference></OutputList><MemoryFractions Input="0.5" Output="0.5"></MemoryFractions><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Column="Expr1008"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="13" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1" EstimateIO="0" EstimateCPU="9.6e-07" AvgRowSize="111" EstimatedTotalSubtreeCost="0.0146561" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="transaction_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_amount"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_timestamp"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="14" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2" EstimateIO="0" EstimateCPU="2e-07" AvgRowSize="111" EstimatedTotalSubtreeCost="0.0146552" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="transaction_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_amount"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_timestamp"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1008"></ColumnReference><ScalarOperator ScalarString="CASE WHEN IsFalseOrNull [Expr1024] THEN [Expr1025] ELSE NULL END"><IF><Condition><ScalarOperator><Logical Operation="IsFalseOrNull"><ScalarOperator><Identifier><ColumnReference Column="Expr1024"></ColumnReference></Identifier></ScalarOperator></Logical></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1025"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="15" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="1.256e-06" AvgRowSize="127" EstimatedTotalSubtreeCost="0.014655" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="transaction_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_amount"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_timestamp"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1025"></ColumnReference></OutputList><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1024"></ColumnReference><ScalarOperator ScalarString="FIRST_VALUE_IS_NULL([fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[win].[balance])"><Aggregate Distinct="0" AggType="FIRST_VALUE_IS_NULL"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="balance"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1025"></ColumnReference><ScalarOperator ScalarString="FIRST_VALUE_IGNORE_NULLS([fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[win].[balance])"><Aggregate Distinct="0" AggType="FIRST_VALUE_IGNORE_NULLS"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="balance"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="transaction_id"></ColumnReference><ScalarOperator ScalarString="ANY([fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[win].[transaction_id])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="transaction_id"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_amount"></ColumnReference><ScalarOperator ScalarString="ANY([fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[win].[win_amount])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_amount"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_timestamp"></ColumnReference><ScalarOperator ScalarString="ANY([fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[win].[win_timestamp])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_timestamp"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Column="WindowCount1033"></ColumnReference></GroupBy><RelOp NodeId="16" PhysicalOp="Window Spool" LogicalOp="Window Spool" EstimateRows="4" EstimateIO="0" EstimateCPU="4.396e-06" AvgRowSize="127" EstimatedTotalSubtreeCost="0.0146537" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="transaction_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_amount"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="balance"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_timestamp"></ColumnReference><ColumnReference Column="WindowCount1033"></ColumnReference><ColumnReference Column="Segment1031"></ColumnReference><ColumnReference Column="Segment1032"></ColumnReference></OutputList><WindowSpool><RelOp NodeId="17" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="2" EstimateIO="0" EstimateCPU="0" AvgRowSize="127" EstimatedTotalSubtreeCost="0.0146488" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="transaction_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_amount"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="balance"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_timestamp"></ColumnReference><ColumnReference Column="Segment1031"></ColumnReference><ColumnReference Column="Segment1032"></ColumnReference></OutputList><Segment><GroupBy><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_timestamp"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1032"></ColumnReference></SegmentColumn><RelOp NodeId="18" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="2" EstimateIO="0" EstimateCPU="1.256e-07" AvgRowSize="119" EstimatedTotalSubtreeCost="0.0146488" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="transaction_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_amount"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="balance"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_timestamp"></ColumnReference><ColumnReference Column="Segment1031"></ColumnReference></OutputList><Segment><GroupBy><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1031"></ColumnReference></SegmentColumn><RelOp NodeId="19" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="2" EstimateIO="0.0112613" EstimateCPU="0.000103231" AvgRowSize="111" EstimatedTotalSubtreeCost="0.0146487" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="transaction_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_amount"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="balance"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_timestamp"></ColumnReference></OutputList><MemoryFractions Input="1" Output="0.5"></MemoryFractions><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference></OrderByColumn><OrderByColumn Ascending="0"><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_timestamp"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="20" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2" EstimatedRowsRead="2" EstimateIO="0.003125" EstimateCPU="0.0001592" AvgRowSize="111" EstimatedTotalSubtreeCost="0.0032842" TableCardinality="2" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="transaction_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_amount"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="balance"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_timestamp"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="transaction_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_amount"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="balance"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_timestamp"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Index="[PK__win__63D79B34F1F9CF8B]" IndexKind="Clustered" Storage="RowStore"></Object></IndexScan></RelOp></Sort></RelOp></Segment></RelOp></Segment></RelOp></WindowSpool></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp><Predicate><ScalarOperator ScalarString="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[bet].[round_id]=[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[win].[round_id]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="round_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></Sort></RelOp></StreamAggregate></RelOp></Sort></RelOp></ComputeScalar></RelOp></NestedLoops></RelOp><RelOp NodeId="21" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="93" EstimatedTotalSubtreeCost="0.0032832" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[cancel]" Column="round_id"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1020"></ColumnReference><ScalarOperator ScalarString="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[cancel].[transaction_id]"><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[cancel]" Column="transaction_id"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1021"></ColumnReference><ScalarOperator ScalarString="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[cancel].[cancel_timestamp]"><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[cancel]" Column="cancel_timestamp"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="22" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="93" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="1" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[cancel]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[cancel]" Column="transaction_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[cancel]" Column="cancel_timestamp"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[cancel]" Column="round_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[cancel]" Column="transaction_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[cancel]" Column="cancel_timestamp"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[cancel]" Index="[PK__cancel__63D79B34F4CAF32C]" IndexKind="Clustered" Storage="RowStore"></Object></IndexScan></RelOp></ComputeScalar></RelOp></NestedLoops></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>


  
SELECT 
  bet.*, 
  win.*, 
  cancel.transaction_id as cancel_transaction_id, 
  cancel.cancel_timestamp 
FROM 
  (
    SELECT 
      round_id, 
      game_id, 
      provider_id, 
      bookmaker_id, 
      user_id, 
      transaction_id as bet_transaction_ids, 
      bet_amount as total_bet, 
      bet_timestamp as bet_timestamp, 
      balance as opening_balance 
    FROM bet
    WHERE 
        bookmaker_id = 1 
        AND provider_id = 1 
        AND transaction_id = 'bet_tx1'
  ) AS bet 
  LEFT JOIN (
    SELECT 
      round_id, 
      STRING_AGG(win.transaction_id, ', ') as win_transaction_ids, 
      SUM(win_amount) as total_won, 
      MAX(win_timestamp) as win_timestamp, 
      closing_balance
    FROM 
      (
        SELECT 
          FIRST_VALUE(balance) OVER (
            PARTITION BY round_id 
            ORDER BY 
              win_timestamp desc
          ) AS closing_balance, 
          * 
        FROM 
          win
      ) AS win 
    -- add filter condition
    WHERE 
        bookmaker_id = 1 
        AND provider_id = 1 
    GROUP BY 
      win.round_id, 
      closing_balance
  ) AS win ON bet.round_id = win.round_id 
  LEFT JOIN cancel ON bet.round_id = cancel.round_id 
  -- add filter condition
  AND bet.bookmaker_id = cancel.bookmaker_id
  AND bet.provider_id = cancel.provider_id
ORDER BY 
  total_won;


Microsoft SQL Server 2005 XML Showplan


<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.539" Build="15.0.4053.23"><BatchSequence><Batch><Statements><StmtSimple StatementText="  &#xa;SELECT &#xa;  bet.*, &#xa;  win.*, &#xa;  cancel.transaction_id as cancel_transaction_id, &#xa;  cancel.cancel_timestamp &#xa;FROM &#xa;  (&#xa;    SELECT &#xa;      round_id, &#xa;      game_id, &#xa;      provider_id, &#xa;      bookmaker_id, &#xa;      user_id, &#xa;      transaction_id as bet_transaction_ids, &#xa;      bet_amount as total_bet, &#xa;      bet_timestamp as bet_timestamp, &#xa;      balance as opening_balance &#xa;    FROM bet&#xa;    WHERE &#xa;        bookmaker_id = 1 &#xa;        AND provider_id = 1 &#xa;        AND transaction_id = &apos;bet_tx1&apos;&#xa;  ) AS bet &#xa;  LEFT JOIN (&#xa;    SELECT &#xa;      round_id, &#xa;      STRING_AGG(win.transaction_id, &apos;, &apos;) as win_transaction_ids, &#xa;      SUM(win_amount) as total_won, &#xa;      MAX(win_timestamp) as win_timestamp, &#xa;      closing_balance&#xa;    FROM &#xa;      (&#xa;        SELECT &#xa;          FIRST_VALUE(balance) OVER (&#xa;            PARTITION BY round_id &#xa;            ORDER BY &#xa;              win_timestamp desc&#xa;          ) AS closing_balance, &#xa;          * &#xa;        FROM &#xa;          win&#xa;      ) AS win &#xa;    -- add filter condition&#xa;    WHERE &#xa;        bookmaker_id = 1 &#xa;        AND provider_id = 1 &#xa;    GROUP BY &#xa;      win.round_id, &#xa;      closing_balance&#xa;  ) AS win ON bet.round_id = win.round_id &#xa;  LEFT JOIN cancel ON bet.round_id = cancel.round_id &#xa;  -- add filter condition&#xa;  AND bet.bookmaker_id = cancel.bookmaker_id&#xa;  AND bet.provider_id = cancel.provider_id&#xa;ORDER BY &#xa;  total_won" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="0.0439603" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xFFEFA8A65C8C99BE" QueryPlanHash="0xEC1E6D296BD47ED6" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="150"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="96" CompileTime="31" CompileCPU="8" CompileMemory="720"><MemoryGrantInfo SerialRequiredMemory="640" SerialDesiredMemory="704" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="838808" EstimatedPagesCached="52425" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="3914648"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2022-06-12T18:13:27.94" ModificationCount="0" SamplingPercent="100" Statistics="[PK__win__63D79B34F1F9CF8B]" Table="[win]" Schema="[dbo]" Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-06-12T18:13:27.94" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000003_267ABA7A]" Table="[cancel]" Schema="[dbo]" Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-06-12T18:13:27.98" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000002_267ABA7A]" Table="[cancel]" Schema="[dbo]" Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-06-12T18:13:27.92" ModificationCount="0" SamplingPercent="100" Statistics="[IX_cancel]" Table="[cancel]" Schema="[dbo]" Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-06-12T18:13:27.94" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000003_24927208]" Table="[win]" Schema="[dbo]" Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-06-12T18:13:27.94" ModificationCount="0" SamplingPercent="100" Statistics="[PK__bet__63D79B344663B27C]" Table="[bet]" Schema="[dbo]" Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-06-12T18:13:27.91" ModificationCount="0" SamplingPercent="100" Statistics="[IX_bet]" Table="[bet]" Schema="[dbo]" Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-06-12T18:13:27.95" ModificationCount="0" SamplingPercent="100" Statistics="[PK__cancel__63D79B34F4CAF32C]" Table="[cancel]" Schema="[dbo]" Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-06-12T18:13:27.92" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000003_22AA2996]" Table="[bet]" Schema="[dbo]" Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-06-12T18:13:27.94" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000002_22AA2996]" Table="[bet]" Schema="[dbo]" Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-06-12T18:13:27.92" ModificationCount="0" SamplingPercent="100" Statistics="[IX_WIN]" Table="[win]" Schema="[dbo]" Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-06-12T18:13:27.95" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000002_24927208]" Table="[win]" Schema="[dbo]" Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><RelOp NodeId="0" PhysicalOp="Nested Loops" LogicalOp="Left Outer Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-06" AvgRowSize="4382" EstimatedTotalSubtreeCost="0.0439603" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bookmaker_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="provider_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="transaction_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="game_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="user_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bet_amount"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="balance"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bet_timestamp"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[cancel]" Column="transaction_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[cancel]" Column="cancel_timestamp"></ColumnReference></OutputList><NestedLoops Optimized="0"><Predicate><ScalarOperator ScalarString="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[bet].[round_id]=[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[cancel].[round_id]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="round_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[cancel]" Column="round_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Predicate><RelOp NodeId="1" PhysicalOp="Nested Loops" LogicalOp="Left Outer Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-06" AvgRowSize="4311" EstimatedTotalSubtreeCost="0.0406727" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bookmaker_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="provider_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="transaction_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="game_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="user_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bet_amount"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="balance"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bet_timestamp"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference></OutputList><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="round_id"></ColumnReference></OuterReferences><RelOp NodeId="2" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="244" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="4" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bookmaker_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="provider_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="transaction_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="game_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="user_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bet_amount"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="balance"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bet_timestamp"></ColumnReference></OutputList><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bookmaker_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="provider_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="round_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="transaction_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="game_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="user_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bet_amount"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="balance"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bet_timestamp"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Index="[PK__bet__63D79B344663B27C]" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="bookmaker_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="provider_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="transaction_id"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator><ScalarOperator ScalarString="N&apos;bet_tx1&apos;"><Const ConstValue="N&apos;bet_tx1&apos;"></Const></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp><RelOp NodeId="3" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="4076" EstimatedTotalSubtreeCost="0.0373854" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1008"></ColumnReference><ScalarOperator ScalarString="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[win].[round_id]"><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1009"></ColumnReference><ScalarOperator ScalarString="[Expr1005]"><Identifier><ColumnReference Column="Expr1005"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1010"></ColumnReference><ScalarOperator ScalarString="[Expr1006]"><Identifier><ColumnReference Column="Expr1006"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1011"></ColumnReference><ScalarOperator ScalarString="[Expr1007]"><Identifier><ColumnReference Column="Expr1007"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1012"></ColumnReference><ScalarOperator ScalarString="[Expr1004]"><Identifier><ColumnReference Column="Expr1004"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="4" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="1" EstimateIO="0.0112613" EstimateCPU="0.000104059" AvgRowSize="4059" EstimatedTotalSubtreeCost="0.0373853" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference></OutputList><MemoryFractions Input="0.5" Output="1"></MemoryFractions><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Column="Expr1006"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="5" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="1.1e-06" AvgRowSize="4059" EstimatedTotalSubtreeCost="0.02602" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference></OutputList><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1005"></ColumnReference><ScalarOperator ScalarString="STRING_AGG([fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[win].[transaction_id],N&apos;, &apos;)"><Aggregate Distinct="0" AggType="STRING_AGG"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="transaction_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="N&apos;, &apos;"></Const></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1006"></ColumnReference><ScalarOperator ScalarString="SUM([fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[win].[win_amount])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_amount"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1007"></ColumnReference><ScalarOperator ScalarString="MAX([fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[win].[win_timestamp])"><Aggregate Distinct="0" AggType="MAX"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_timestamp"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference><ScalarOperator ScalarString="ANY([fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[win].[round_id])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Column="Expr1004"></ColumnReference></GroupBy><RelOp NodeId="6" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="1" EstimateIO="0.0112613" EstimateCPU="0.000100111" AvgRowSize="111" EstimatedTotalSubtreeCost="0.0260189" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="transaction_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_amount"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_timestamp"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OutputList><MemoryFractions Input="0.5" Output="0.5"></MemoryFractions><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Column="Expr1004"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="7" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1" EstimateIO="0" EstimateCPU="2.36e-06" AvgRowSize="111" EstimatedTotalSubtreeCost="0.0146575" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="transaction_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_amount"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_timestamp"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OutputList><Filter StartupExpression="0"><RelOp NodeId="8" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2" EstimateIO="0" EstimateCPU="2e-07" AvgRowSize="119" EstimatedTotalSubtreeCost="0.0146552" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="bookmaker_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="provider_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="transaction_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_amount"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_timestamp"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1004"></ColumnReference><ScalarOperator ScalarString="CASE WHEN IsFalseOrNull [Expr1015] THEN [Expr1016] ELSE NULL END"><IF><Condition><ScalarOperator><Logical Operation="IsFalseOrNull"><ScalarOperator><Identifier><ColumnReference Column="Expr1015"></ColumnReference></Identifier></ScalarOperator></Logical></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1016"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="9" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="1.256e-06" AvgRowSize="135" EstimatedTotalSubtreeCost="0.014655" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="bookmaker_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="provider_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="transaction_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_amount"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_timestamp"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference></OutputList><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1015"></ColumnReference><ScalarOperator ScalarString="FIRST_VALUE_IS_NULL([fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[win].[balance])"><Aggregate Distinct="0" AggType="FIRST_VALUE_IS_NULL"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="balance"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1016"></ColumnReference><ScalarOperator ScalarString="FIRST_VALUE_IGNORE_NULLS([fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[win].[balance])"><Aggregate Distinct="0" AggType="FIRST_VALUE_IGNORE_NULLS"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="balance"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="bookmaker_id"></ColumnReference><ScalarOperator ScalarString="ANY([fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[win].[bookmaker_id])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="bookmaker_id"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="provider_id"></ColumnReference><ScalarOperator ScalarString="ANY([fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[win].[provider_id])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="provider_id"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="transaction_id"></ColumnReference><ScalarOperator ScalarString="ANY([fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[win].[transaction_id])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="transaction_id"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_amount"></ColumnReference><ScalarOperator ScalarString="ANY([fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[win].[win_amount])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_amount"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_timestamp"></ColumnReference><ScalarOperator ScalarString="ANY([fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[win].[win_timestamp])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_timestamp"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Column="WindowCount1021"></ColumnReference></GroupBy><RelOp NodeId="10" PhysicalOp="Window Spool" LogicalOp="Window Spool" EstimateRows="4" EstimateIO="0" EstimateCPU="4.396e-06" AvgRowSize="135" EstimatedTotalSubtreeCost="0.0146537" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="bookmaker_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="provider_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="transaction_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_amount"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="balance"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_timestamp"></ColumnReference><ColumnReference Column="WindowCount1021"></ColumnReference><ColumnReference Column="Segment1019"></ColumnReference><ColumnReference Column="Segment1020"></ColumnReference></OutputList><WindowSpool><RelOp NodeId="11" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="2" EstimateIO="0" EstimateCPU="0" AvgRowSize="135" EstimatedTotalSubtreeCost="0.0146488" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="bookmaker_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="provider_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="transaction_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_amount"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="balance"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_timestamp"></ColumnReference><ColumnReference Column="Segment1019"></ColumnReference><ColumnReference Column="Segment1020"></ColumnReference></OutputList><Segment><GroupBy><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_timestamp"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1020"></ColumnReference></SegmentColumn><RelOp NodeId="12" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="2" EstimateIO="0" EstimateCPU="1.256e-07" AvgRowSize="127" EstimatedTotalSubtreeCost="0.0146488" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="bookmaker_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="provider_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="transaction_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_amount"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="balance"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_timestamp"></ColumnReference><ColumnReference Column="Segment1019"></ColumnReference></OutputList><Segment><GroupBy><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1019"></ColumnReference></SegmentColumn><RelOp NodeId="13" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="2" EstimateIO="0.0112613" EstimateCPU="0.000103239" AvgRowSize="119" EstimatedTotalSubtreeCost="0.0146487" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="bookmaker_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="provider_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="transaction_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_amount"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="balance"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_timestamp"></ColumnReference></OutputList><MemoryFractions Input="1" Output="0.5"></MemoryFractions><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference></OrderByColumn><OrderByColumn Ascending="0"><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_timestamp"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="14" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2" EstimatedRowsRead="2" EstimateIO="0.003125" EstimateCPU="0.0001592" AvgRowSize="119" EstimatedTotalSubtreeCost="0.0032842" TableCardinality="2" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="bookmaker_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="provider_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="transaction_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_amount"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="balance"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_timestamp"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="bookmaker_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="provider_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="transaction_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_amount"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="balance"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="win_timestamp"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Index="[PK__win__63D79B34F1F9CF8B]" IndexKind="Clustered" Storage="RowStore"></Object></IndexScan></RelOp></Sort></RelOp></Segment></RelOp></Segment></RelOp></WindowSpool></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp><Predicate><ScalarOperator ScalarString="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[bet].[round_id]=[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[win].[round_id] AND [fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[win].[bookmaker_id]=(1) AND [fiddle_c3cf976d3bbc4a60bf63db9ece7308e4].[dbo].[win].[provider_id]=(1)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[bet]" Column="round_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="round_id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="bookmaker_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[win]" Column="provider_id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp></Sort></RelOp></StreamAggregate></RelOp></Sort></RelOp></ComputeScalar></RelOp></NestedLoops></RelOp><RelOp NodeId="15" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="93" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="1" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[cancel]" Column="round_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[cancel]" Column="transaction_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[cancel]" Column="cancel_timestamp"></ColumnReference></OutputList><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[cancel]" Column="round_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[cancel]" Column="transaction_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[cancel]" Column="cancel_timestamp"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[cancel]" Index="[PK__cancel__63D79B34F4CAF32C]" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[cancel]" Column="bookmaker_id"></ColumnReference><ColumnReference Database="[fiddle_c3cf976d3bbc4a60bf63db9ece7308e4]" Schema="[dbo]" Table="[cancel]" Column="provider_id"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>