Query editor
withcounted AS (SELECT'FF' AS locator, evt_block_time, token0, token1,1 AS counts,LEAST(CAST(token0 AS varchar),CAST(token1 AS varchar)) || '_' || GREATEST(CAST(token0 AS varchar),CAST(token1 as varchar)) AS pair_alphaFROM graphene_mantle.CarbonController_evt_StrategyCreated),counted2 AS (SELECT'FF' AS locator,COUNT(distinct trader) AS unique_traders,COUNT(evt_tx_hash) AS trade_countFROM graphene_mantle.CarbonController_evt_TokensTraded)SELECTSUM(counts) AS strat_count,COUNT(DISTINCT pair_alpha) AS unique_pairs,(SELECT COUNT(*) FROM query_3900460) AS active_pairs,MAX(unique_traders) AS unique_traders,MAX(trade_count) AS trade_countsFROM counted c1LEFT JOIN counted2 c2 ON c1.locator = c2.locator