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"HAVING SUM(CASEWHEN "to" = "to" THEN TRY_CAST(value AS DOUBLE)WHEN "from" = "to" THEN -TRY_CAST(value AS DOUBLE)END) / 1e18 > 0)SELECTCOUNT(*) as total_holders,ROUND(SUM(balance), 2) as total_supplyFROM holder_balance