active_days as (

distinct from_address as users,

count(distinct trunc(block_timestamp,'day')) as active_days

from avalanche.core.fact_transactions

group by 1)

select

case when active_days=1 then 'A) 1 day'

when active_days<=5 then 'B) between 1 and 5 days'

when active_days<=10 then 'C) between 5 and 10 days'

when active_days<=20 then 'D) between 10 and 20 days'

else 'E) more than 20 days'

end as "Frequency",

count(users) as "count"

from active_days

group by 1

order by 2 desc