with old_address as (
select distinct tx_from[0] as address from terra.transactions
where date(block_timestamp) < CURRENT_DATE() - interval '90 day' and tx_from !=''
)
,nintydaysago_address as (
select distinct tx_from[0] as new_address from terra.transactions where
date(block_timestamp) > CURRENT_DATE() - interval '90 day'
and tx_from !=''
and tx_from[0] not in (select address from old_address)
)
,final_result as (
select count(*) as c,date(block_timestamp) as date
from terra.staking
where delegator_address in(select new_address from nintydaysago_address)
group by date
)
select * from final_result