with userstable as (

select tx_from,

count (distinct tx_Id) as Transactions,

sum (fee/1e6) as Fees,

count (distinct block_timestamp::date) as acitve_days

from lava.core.fact_transactions

where block_timestamp >= '2024-07-30 11:00:00.000' -- Public Mainnet Launch

group by 1)

select case when acitve_days = 1 then '1 Day'

when acitve_days > 1 and acitve_days <= 7 then '1 - 7 Days'

when acitve_days > 7 and acitve_days <= 14 then '7 - 14 Days'

when acitve_days > 14 and acitve_days <= 31 then '14 - 31 Days'

else '> 31 Days' end as type,

count (distinct tx_from) as Users

from userstable

group by 1

order by 2 desc