Query editor
WITH holder_balance AS (SELECT"to" AS holder,SUM(CASEWHEN "to" = "to"THEN TRY_CAST(value AS DOUBLE)WHEN "from" = "to"THEN -TRY_CAST(value AS DOUBLE)END) / 1e18 AS balanceFROM erc20_ethereum.evt_TransferWHEREcontract_address = FROM_HEX('cf0c122c6b73ff809c693db761e7baebe62b6a2e')GROUP BY"to"HAVINGSUM(CASEWHEN "to" = "to"THEN TRY_CAST(value AS DOUBLE)WHEN "from" = "to"THEN -TRY_CAST(value AS DOUBLE)END) / 1e18 > 0)SELECTCASEWHEN balance >= 100000THEN 'Whale (>100K)'WHEN balance >= 50000THEN 'Large (50K-100K)'WHEN balance >= 10000THEN 'Medium (10K-50K)'WHEN balance >= 5000THEN 'Small (5K-10K)'WHEN balance >= 1000THEN 'Mini (1K-5K)'ELSE 'Retail (<1K)'END AS holder_category,COUNT(*) AS number_of_holders,ROUND(SUM(balance), 2) AS total_holdings,ROUND(100.0 * COUNT(*) / SUM(COUNT(*)) OVER (), 2) AS percentage_of_holdersFROM holder_balanceGROUP BY1ORDER BYMIN(balance) DESC