select

distinct from_address as User_address,

count(distinct tx_hash) as "# TXs"

from

avalanche.core.fact_transactions

where

to_address = '0x5898c3e218a8501533d771c86e2fa37743ea2add'

and STATUS = 'SUCCESS'

group by

1

case

when "# TXs" = 1 then 'A: 1 TXs'

when "# TXs" > 1

and "# TXs" <= 3 then 'B: 1-3 TXs'

when "# TXs" > 3

and "# TXs" <= 5 then 'C: 3-5 TXs'

when "# TXs" > 5

and "# TXs" <= 10 then 'D: 5-10 TXs'

when "# TXs" > 10

and "# TXs" <= 100 then 'E: 10-100 TXs'

else 'F: > 100 TXs'

end as Status,

count(distinct User_address) as "# Users"

User_stats

group by

1