select tx_sender,

min (block_timestamp)::date as min_date

from terra.core.fact_transactions

group by 1

),

t2 as (

tx_sender,

datediff (day, min_date, current_date) as age

from t1

when age = 1 then '1 Day'

when age < 30 then 'Between 1 - 30 Days'

when age < 60 then 'Between 30 - 60 Days'

when age < 90 then 'Between 60 - 90 Days'

when age < 180 then 'Between 90 - 180 Days'

when age < 364 then 'Between 180 - 364 Days'

else 'More Than 1 Year' end as type,

count (distinct tx_sender) as users_count

from t2

group by 1