Query editor
WITH elig AS (-- 直接把上一个 query 作为 CTE 复制进来更省事;这里简写:假设你已经保存成 query viewSELECT wallet, balance_meth, tierFROM (SELECTaddr AS wallet,balance_meth,CASEWHEN balance_meth >= 100 THEN 'C_100+'WHEN balance_meth >= 10 THEN 'B_10-100'WHEN balance_meth >= 1 THEN 'A_1-10'ELSE 'NOT_ELIGIBLE'END AS tierFROM (SELECTaddr,sum(delta) / CAST(1e18 AS DECIMAL(38,0)) AS balance_methFROM (SELECT evt_block_time, "to" AS addr, CAST(value AS DECIMAL(38,0)) AS deltaFROM mantle_ethereum.meth_evt_transferUNION ALLSELECT evt_block_time, "from" AS addr, -CAST(value AS DECIMAL(38,0)) AS deltaFROM mantle_ethereum.meth_evt_transfer) flowsWHERE evt_block_time < TIMESTAMP '2026-01-01 00:00:00'GROUP BY 1) b) xWHERE tier <> 'NOT_ELIGIBLE'),rewards AS (SELECTwallet,tier,CASEWHEN tier = 'A_1-10' THEN 10WHEN tier = 'B_10-100' THEN 50WHEN tier = 'C_100+' THEN 200ELSE 0END AS reward_pointsFROM elig)SELECTtier,count(*) AS wallets,sum(reward_points) AS total_points,avg(reward_points) AS avg_pointsFROM rewardsGROUP BY 1ORDER BY 1;