Query editor
WITH manta AS (SELECTSUM(value / CAST(1e18 AS DOUBLE)) AS total,"from"FROM ethereum."transactions"WHERE"to" = 0x3B95bC951EE0f553ba487327278cAc44f29715E5 AND value > 0 AND successGROUP BY"from")SELECTCOUNT(DISTINCT manta."from") AS depositors,CASEWHEN manta.total < 0.01THEN '0--0.01 ETH'WHEN manta.total BETWEEN 0.01 AND 0.1THEN '0.01-0.1 ETH'WHEN manta.total BETWEEN 0.1 AND 1THEN '0.1-1 ETH'WHEN manta.total BETWEEN 1 AND 2THEN '1-2 ETH'WHEN manta.total BETWEEN 2 AND 3THEN '2-3 ETH'WHEN manta.total BETWEEN 3 AND 4THEN '3-4 ETH'WHEN manta.total BETWEEN 4 AND 5THEN '4-5 ETH'WHEN manta.total BETWEEN 5 AND 6THEN '5-6 ETH'WHEN manta.total BETWEEN 6 AND 7THEN '6-7 ETH'WHEN manta.total BETWEEN 7 AND 9THEN '7-8 ETH'WHEN manta.total BETWEEN 8 AND 9THEN '8-9 ETH'WHEN manta.total BETWEEN 9 AND 10THEN '9-10 ETH'WHEN manta.total BETWEEN 10 AND 15THEN '10-15 ETH'WHEN manta.total BETWEEN 15 AND 20THEN '15-20 ETH'ELSE '20+ ETH'END AS "eth_value_range"FROM mantaGROUP BY2