SELECT

CASE

WHEN value <= 0.01 THEN '0-0.01 ETH'

WHEN value <= 0.1 THEN '0.01-0.1 ETH'

WHEN value <= 0.5 THEN '0.1-0.5 ETH'

WHEN value <= 1.0 THEN '0.5-1 ETH'

WHEN value <= 2.0 THEN '1-2 ETH'

WHEN value <= 5.0 THEN '2-5 ETH'

ELSE '5+ ETH'

END as value_range,

COUNT(DISTINCT from_address) as number_of_users

FROM swell.core.fact_transactions

where value > 0

AND tx_succeeded = true

GROUP BY

CASE

WHEN value <= 0.01 THEN '0-0.01 ETH'

WHEN value <= 0.1 THEN '0.01-0.1 ETH'

WHEN value <= 0.5 THEN '0.1-0.5 ETH'

WHEN value <= 1.0 THEN '0.5-1 ETH'

WHEN value <= 2.0 THEN '1-2 ETH'

WHEN value <= 5.0 THEN '2-5 ETH'

ELSE '5+ ETH'

END

SELECT

value_range,

number_of_users,

ROUND(100.0 * number_of_users / SUM(number_of_users) OVER (), 2) as percentage

FROM value_groups

ORDER BY

CASE value_range

WHEN '0-0.01 ETH' THEN 1

WHEN '0.01-0.1 ETH' THEN 2