Query editor
WITH wallet_stats AS (SELECT"from" AS wallet,COUNT(*) AS tx_count,SUM(TRY_CAST(value AS DOUBLE)) / 1e18 AS total_volume,'Seller' AS wallet_type,COUNT(DISTINCT DATE_TRUNC('day', evt_block_time)) AS active_daysFROM erc20_ethereum.evt_TransferWHEREcontract_address = 0xcf0c122c6b73ff809c693db761e7baebe62b6a2eAND evt_block_time >= CURRENT_DATE - INTERVAL '30' dayGROUP BY1UNION ALLSELECT"to" AS wallet,COUNT(*) AS tx_count,SUM(TRY_CAST(value AS DOUBLE)) / 1e18 AS total_volume,'Buyer' AS wallet_type,COUNT(DISTINCT DATE_TRUNC('day', evt_block_time)) AS active_daysFROM erc20_ethereum.evt_TransferWHEREcontract_address = 0xcf0c122c6b73ff809c693db761e7baebe62b6a2eAND evt_block_time >= CURRENT_DATE - INTERVAL '30' dayGROUP BY1)SELECTwallet,SUM(tx_count) AS total_transactions,ROUND(SUM(total_volume), 2) AS total_volume,MAX(active_days) AS days_active,ARRAY_AGG(DISTINCT wallet_type) AS activity_type, /* Use array_agg(...) instead of GROUP_CONCAT(DISTINCT... ) */ROUND(TRY_CAST(SUM(tx_count) AS DECIMAL) / MAX(active_days), 2) AS avg_daily_txFROM wallet_statsGROUP BY1HAVINGSUM(tx_count) > 5ORDER BYtotal_transactions DESCLIMIT 10