with
validators as (
select
validator_address,
count(distinct tx_id) as counts
from osmosis.core.fact_staking
where action = 'redelegate'
group by 1
)
select
y.label as validator_name,
x.counts as redelegations
from validators x
join osmosis.core.dim_labels y on x.validator_address=y.address
where redelegations >100
order by 2 desc