SELECT

block_timestamp,

tx_hash,

origin_from_address AS user_Address,

amount

FROM

ethereum.core.ez_token_transfers

WHERE

origin_to_address = '0x94fdc38c4a8e34248f8dd19cb3336e0295227023'

AND block_timestamp >= '2024-08-26'

SELECT

CASE

WHEN amount < 50 THEN '< 50'

WHEN amount >= 50 AND amount < 100 THEN '50-100'

WHEN amount >= 100 AND amount < 500 THEN '100-500'

WHEN amount >= 500 AND amount < 1000 THEN '500-1000'

ELSE '>= 1000'

END AS amount_range,

COUNT(DISTINCT user_Address) AS total_users,

SUM(amount) AS total_claimed_amount

FROM

orderly

GROUP BY

amount_range

ORDER BY

amount_range;