with active_days as (select from_address,

count(DISTINCT block_timestamp::date) as days,

count(DISTINCT tx_hash) as total_transactions,

count(DISTINCT block_number) as blocks,

sum(tx_fee) as fees_bera

from berachain.testnet.fact_transactions

group by 1)

select count(DISTINCT from_address) as users,

case when days = 1 then 'a. 1 Day'

when days = 2 then 'b. 2 Days'

when days = 3 then 'c. 3 Days'

when days = 4 then 'd. 4 Days'

when days = 5 then 'e. 5 Days'

when days = 6 then 'f. 6 Days'

when days = 7 then 'g. 7 Days'

when days <= 14 then 'h. 1-2 Weeks'

when days <= 21 then 'i. 2-3 Weeks'

when days <= 30 then 'j. 3-4 Weeks'

when days > 30 then 'k. > 1 Month' end as breakdown

from active_days

group by 2

order by 2 asc