select tx_sender,

count (distinct tx_id) as txns_count,

count (distinct block_timestamp::date) as active_days_count

from terra.core.fact_transactions

where fee_denom = 'uluna'

group by 1

when active_days_count = 1 then '1 Day'

when active_days_count <= 10 then 'Between 1 - 10 Days'

when active_days_count <= 30 then 'Between 10 - 30 Days'

when active_days_count <= 60 then 'Between 30 - 60 Days'

when active_days_count <= 90 then 'Between 60 - 90 Days'

else 'More Than 90 Days' end as type,

count (distinct tx_sender) as users_count

from t1

group by 1