with stake_dtls as (

select

date(block_timestamp) as stake_day,

delegator_address as staker_address

from

osmosis.core.fact_staking

where

action = 'delegate'

),

unstake_dtls as (

select

date(block_timestamp) as unstake_day,

delegator_address as unstaker_address

from

osmosis.core.fact_staking

where

action = 'undelegate'

),

unstake_durations as (

select

datediff('day', stake_day, unstake_day) as duration,

unstake_day,

staker_address as wallet

from

stake_dtls

inner join unstake_dtls on staker_address = unstaker_address

and unstake_day > stake_day

)

select

validator_address as validator,

count(distinct delegator_address) as no_of_wallets

from

osmosis.core.fact_staking a

join unstake_durations b on block_timestamp > b.unstake_day