SELECT

origin_from_address,

SUM(decoded_log:avaxAmount / POW(10, 18)) AS avax

FROM

avalanche.core.ez_decoded_event_logs

WHERE

contract_address = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'

AND event_name = 'Submitted'

AND block_timestamp::DATE >= '2024-01-01'

GROUP BY

origin_from_address

SELECT

CASE

WHEN avax < 1 THEN 'Less Than 1 AVAX'

WHEN avax >= 1 AND avax < 10 THEN '1 - 10 AVAX'

WHEN avax >= 10 AND avax < 100 THEN '10 - 100 AVAX'

ELSE 'More Than 100 AVAX'

END AS avax_range,

COUNT(DISTINCT origin_from_address) AS user_count

FROM

base

GROUP BY

avax_range;