select

tx_hash,

block_timestamp,

to_address as user,

amount,

amount_usd

from ronin.core.ez_token_transfers

where origin_to_address = '0x0cf8ff40a508bdbc39fbe1bb679dcba64e65c7df'

),

classified as (

select

tx_hash,

user,

amount,

amount_usd,

case

when amount_usd < 100 then 'Small (< $100)'

when amount_usd between 100 and 1000 then 'Medium ($100-$1000)'

else 'Large (> $1000)'

end as category

from main

select

category,

count(tx_hash) as tx_count,

sum(amount) as total_amount,

sum(amount_usd) as total_amount_usd

from classified

group by category

order by total_amount_usd desc;